home bbs files messages ]

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