trimspool will remove the trailing blanks and get rid of the padding
- "Fink, Dan" <Dan.Fink_at_mdx.com> wrote:
> 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-----
> Sent: Monday, June 10, 2002 11:28 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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 recipients of list <mailto:ORACLE-L_at_fatcity.com>
> 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: wisernet100_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Mon Jun 10 2002 - 15:28:31 CDT