Re: sqlplus format issue

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Tue, 5 Jan 2010 16:36:59 -0600
Message-ID: <e9569ef31001051436he64d657l5054bcefdac2fc04_at_mail.gmail.com>

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_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
> row?
>
>
>
> My concern is that ‘set linesize 1500’ makes the spool file too big because
> those white spaces.
>
>
>
> Thanks,
>
> Lei
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 05 2010 - 16:36:59 CST