home *** CD-ROM | disk | FTP | other *** search
/ Piper's Pit BBS/FTP: ibm 0000 - 0009 / ibm0000-0009 / ibm0003.tar / ibm0003 / ORACLE01.ZIP / QRY_ORCL.SQL < prev    next >
Encoding:
Text File  |  1987-08-27  |  120 b   |  7 lines
  1. system/manager
  2.  
  3.  
  4. select decode(tname,'TAB','Oracle is up.',NULL) IS_ORACLE_UP
  5. from tab where tname = 'TAB';
  6. exit
  7.