Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle    |    Overblown overpriced overengineered SHIT    |    2,288 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 1,120 of 2,288    |
|    .com to Joe Christl    |
|    Re: Simple SQL to display text    |
|    19 Feb 04 17:56:52    |
   
   From: mcstockX@Xenquery   
      
   "Joe Christl" wrote in message   
   news:e9cd3ea2.0402190940.6b465ce1@posting.google.com...   
   | I was wondering - is there some part of sql that can display text?   
   | I wanted to add simple instruictions to the beginning of an sql script   
   | so the user understands what they're entering into the '&value' entry   
   | of the SELECT portion of the script.   
   |   
   | I know that anything with REM in the beginning is simply ignored.   
   |   
   | Thanks for your help.   
      
   Not SQL, you're actually asking about SQL*Plus (Oracle very basic UI tool)   
      
   PROMPT for one line   
      
   DOC for multiple lines (terminate with #) -- or use a c-style multiple line   
   comment (equivalent of DOC...#)   
      
      
   lots more good stuff in the SQL*Plus manual! -- you might also want to check   
   out the ACCEPT statement   
      
   -{ mcs   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca