Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting Oracle Database into text file
Thor HW wrote:
>
> > set feedback off
> > set heading off
> > set pagesize 0
> > set linesize 210
> > set space 0
> > set newpage 0
> > set verify off
> > set termout off
> > set echo off
> > set wrap off
> > set flush off
>
> good list ... although I add
> set trimspool on
> and set my linesize to 2000
>
> The trimspool will not pad out the line with white space.
>
> Thor HW
I thought I mentioned linesize determines the size of the record if you want fixed length. I didn't know about TRIMSPOOL. Thanks. I'll use that next time.
John johnjc_at_ns.net , caputo1_at_llnl.gov Received on Tue Jul 15 1997 - 00:00:00 CDT