Setting SQLPROMPT to '' is very handy, but there is one caveat. After the query executes, SQL*Plus 'appears' to hang because there is no prompt to indicate where the next command is to be entered(like SET PAUSE ON and forgetting about it...d'oh).
I spooled as much as 10,000 characters on a single line without problem. However, there is a limit of 2500 characters for the command line and the LINESIZE is platform dependent. Do you have an example we could chew on? Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -----Original Message----- Sent: Monday, June 10, 2002 1:18 PM To: Multiple recipients of list ORACLE-L You can also add set feedback off This will stop any row counts from appearing at the end of the query. Plus you can set sqlprompt '' This will change the standard SQL> prompt to nothing. This way the SQL> that returns at the end of the query . Its anoying . -----Original Message----- Sent: Monday, June 10, 2002 12:58 PM To: Multiple recipients of list ORACLE-L set pagesize 0 as well, that stops the heading lines from breaking up your output --- [EMAIL PROTECTED] wrote: > set linesize alone doesn't help - but will try it with set trimspool > > -----Original Message----- > Sent: Monday, June 10, 2002 12:48 PM > To: Multiple recipients of list ORACLE-L > > > Oracle doesn't place anything. SQL*Plus does. > If you generate scripts from SQL*Plus: > set linesize ... > > -- > Alexandre > > ----- Original Message ----- > To: Multiple <mailto:[EMAIL PROTECTED]> recipients of list > ORACLE-L > Sent: Monday, June 10, 2002 3:58 PM > > > Guys, > > Building scripts from SQL generating SQL in Oracle on Unix. I know > that > there are set commands so that Oracle does not put CR or LF in the > middle of > a long command. Does anyone know these off the top of their head? > > Thanks, > Paula > > set array...? > set maxdata...? > > __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan 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).