Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL generating SQL - stupid question continued lines

Re: SQL generating SQL - stupid question continued lines

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 19 Aug 2004 21:25:41 +0100
Message-ID: <7765c8970408191325496b7d80@mail.gmail.com>


On Thu, 19 Aug 2004 13:28:14 -0400, Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us> wrote:
> 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.

true story 2 - this one is me though.

take one script

select RPAD(col,255,' ') colname
from tab
where (some marginally imaginative logic)

wrap in

set trimspool on
spool filename

ponder for 36 hours why RPAD wasn't working :)

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
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 - 15:21:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US