RE: SQL generating SQL - stupid question continued lines

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Thu, 19 Aug 2004 13:28:14 -0400
Message-ID: <543DF856D23431489D4B8028C300FBAB08AC93BD@exchsen0a1mb>

I also like 'set trimspool on'

Removes trailing spaces. It thus allows you to 'set lines 2000' - trailing spaces get chopped off. If you ever open the resulting script file, it makes your life a little bit easier.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Daniel W. Fink [mailto:Daniel.Fink_at_Sun.COM] Sent: Thursday, August 19, 2004 1:07 PM
To: oracle-l_at_freelists.org
Subject: Re: SQL generating SQL - stupid question continued lines

Paula,

There are several things to look at. 1) Make sure the size of the output 'column' is large enough to enable breaks to occur properly. 2) When setting linesize, add in any columns that are NOPRINT. Make it large enough that it has plenty of buffer spaces. 3) SET RECSEP OFF. The default is WRAPPED which adds in an additional line if a record is 'wrapped'.

Daniel Fink

Paula_Stankus_at_doh.state.fl.us wrote:

>Guys,
>
>I hope you don't mind answering this - I am sure I answered this at one
>= time but now forgot the answer.
>
>I have some SQL generating SQL but there are skipped lines so the =
>commands do not look correct and I get=20
>
>SP2-....unknown command.
>
>What is the set command to change this behavior?
>
>Thanks,
>Paula
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org put
>'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Aug 19 2004 - 12:24:43 CDT