RE: set command

[Toepke, Kevin M]

Title: RE: set command

Here is what I use. It wraps at the 32768th character.   SET PAUSE OFF SET TRIMSPOOL ON SET TRIMOUT   ON SET TERMOUT   OFF SET PAGESIZE  50000 SET LINESIZE  32767 -----Original Message----- From: Fink, Dan [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: set command Paula,     TRIMSPOOL will only remove the trailing characters in an output file. Normally, the output is padded with blanks up to the length defined by LINESIZE. I don't think TRIMSPOOL will help, but I could be wrong.       How long is the command you are trying to output? What is the setting for WRAP?   Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 11:28 AM To: Multiple recipients of list ORACLE-L Subject: RE: set command set linesize alone doesn't help - but will try it with set trimspool -----Original Message----- From: Alexandre Gorbatchev [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 12:48 PM To: Multiple recipients of list ORACLE-L Subject: Re: set command Oracle doesn't place anything. SQL*Plus does. If you generate scripts from SQL*Plus: set linesize ...   -- Alexandre ----- Original Message ----- From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, June 10, 2002 3:58 PM Subject: RE: set command 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...?