Re: sqlplus question

Tried this. The field length is still 56.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, September 19, 2002 6:43 PM

> select substr(ename,1,length(ename)), job from emp;
>
> >From: "Bob Metelsky" <bmetelsky_at_cps92.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: sqlplus question
> >Date: Thu, 19 Sep 2002 08:18:51 -0800
> >
> >
> > >
> > > I am spooling my sqlplus output to a file with no
> > > headings and all the fields separated by a delimiter. I have
> > > a field that is defined as varchar2(56), but typically only 4
> > > or 5 bytes are filled. Oracle recognizes that and if you
> > > select length(fld1) from the table, you will get 4. But if I
> > > spool this to a file, I always get the full 56 bytes padded
> > > with blanks. In other words, I get 4 bytes of data and 52
> > > blanks for that field. I only want the four valid bytes so
> > > that my delimiter comes immediately after that 4th byte. My
> > > sqlplus options are as follows:
> > >
> > > set newpage 0 space 0 linesize 5000 pagesize 0 echo off
> > > recsep off feedback off heading off trimspool on colsep "|"
> >
> >Sounds to me like the trimspool should do it...
> >
> >Are you sure its set on
> >
> >ME_at_DB1 -> trimspool on
> >SP2-0734: unknown command beginning "trimspool ..." - rest of line
> >ignored.
> >
> >Try set trims on
> >
> >Or
> >
> >Set trimspool on
> >
> >
> >bob
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Bob Metelsky
> > INET: bmetelsky_at_cps92.com
> >
> >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> >San Diego, California -- Mailing list and web hosting services
> >---------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
>
>
>
> _________________________________________________________________
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Viral Desai
> INET: viral303_at_hotmail.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).