Re: sqlplus format issue

From: Bradd Piontek <>
Date: Tue, 5 Jan 2010 16:36:59 -0600
Message-ID: <>

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
  • William Feather

On Tue, Jan 5, 2010 at 4:30 PM, Lei Zeng <> 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

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

Original text of this message