RE: sqlplus format issue
- From: "Lei Zeng" <lzeng@xxxxxxxxxxxxx>
- To: <piontekdd@xxxxxxxxx>
- Date: Tue, 5 Jan 2010 15:39:36 -0800
It works, Thank you all !!!
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bradd Piontek
Sent: Tuesday, January 05, 2010 2:37 PM
To: Lei Zeng
Cc: oracle-l
Subject: Re: sqlplus format issue
You will want to 'set trimspool on' to get rid of the trailing
whitespaces. That should reduce the size of your spool file
considerably.
Bradd Piontek
"Next to doing a good job yourself,
the greatest joy is in having someone
else do a first-class job under your
direction."
-- William Feather
On Tue, Jan 5, 2010 at 4:30 PM, Lei Zeng <lzeng@xxxxxxxxxxxxx> 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 row?
My concern is that 'set linesize 1500' makes the spool file too big
because those white spaces.
Thanks,
Lei
Other related posts:
