| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: sqlplus question
Use rtrim and ltrim are you sure data was loaded with spaces?
-----Original Message-----
From: Yechiel Adar [mailto:adar76@inter.net.il]
Sent: Thursday, September 19, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L
Subject: 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@fatcity.com>
Sent: Thursday, September 19, 2002 6:43 PM
> select substr(ename,1,length(ename)), job from emp;
>
> >From: "Bob Metelsky" <bmetelsky@cps92.com>
> >Reply-To: ORACLE-L@fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L@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@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@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@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@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@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@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@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: INET: Paula_Stankus_at_doh.state.fl.us 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 - 17:53:39 CDT
 |
 |