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).
