Re: sqlplus format issue
Date: Tue, 5 Jan 2010 16:36:14 -0600
Use 'set trimspool on'
On Tue, Jan 5, 2010 at 4:30 PM, Lei Zeng <lzeng_at_yahoo-inc.com> wrote:
> Hi, I have a quick question about using sqlplus here. There is a
> requirement to select 1 column and spool out to a plain text file. The data
> type if varchar2(1500) but most of rows are only 100 characters long, only
> few are >1000 characters. I would like the spool file have one line for each
> row, doest that mean I have NO other choice but set linesize 1500 ? is
> there another way to tell sqlplus do not wrap into new line for one table
> My concern is that set linesize 1500 makes the spool file too big because
> those white spaces.