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).
Received on Thu Sep 19 2002 - 11:43:35 CDT
