RE: SQL generating SQL - stupid question continued lines
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Aug 2004 13:28:14 -0400
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@xxxxxxx]
Sent: Thursday, August 19, 2004 1:07 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxx 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@xxxxxxxxxxxxx put
>'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
