On Thu, 19 Aug 2004 13:28:14 -0400, Mercadante, Thomas F <thomas.mercadante@xxxxxxxxxxxxxxxxx> 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@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 -----------------------------------------------------------------