"Farnsworth, Dave" wrote: > > I have a script that I run to update statistics on my databases that is giving me >something odd when run on a 7.3.4 database on NT 4.0. The script runs fine on my >8.1.7 and 8.0.5 databases. It happens when the script comes to an end. Below is >what my screen looks like in SQLPlus; > > SQL> analyze table MP2.MOSIA_OUT_POLINE compute statistics; > > Table analyzed. > > SQL> analyze table MP2.REQORDOP compute statistics; > > Table analyzed. > > SQL> DOC>*/ > DOC>spool off > DOC>exit > DOC> > DOC> > > What is happening when the prompt goes from "SQL>" to "DOC>"?? This does not happen >on the 8.x databases. The script finishes without errors but I don't know what this >is. Any ideas?? > > Thanks, > > Dave
Related to the now obsolete DOCUMENT SQL*Plus command, once used to echo everything and create (when spooling) kind of SQL tutorials. I have never found it very useful, anyway. Musn't be alone since it is now obsolete. Must be turned on by '/*' somewhere in your script. Keep C style comments INSIDE statements (I only use them for hints, and I try not do it too often). REM can only be used in SQL*Plus scripts. IMHO the best choice for comments is --. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
