Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Rtrim seems not to work as expected
TurkBear wrote:
> Details:
> Oracle 8.1.7.4
> SqlPlus 9.2
> W2K Advanced Server
>
> I am confused ( not a rare thing) , because I thought I had done this kind of thing before:
> Create a CSV spool file from the database..
>
> Set colsep to ','
> set heading, feedback, etc off
> got the following:( employee numbers deleted for security - names are public data.
> -------------------------------------------------------------------------------------------------------------------------------------
> select rtrim(empl_nm),empl_nbr from hr_public where rownum < 9;
>
> Lambert,Ronald Paul ,00000000
> Hopkins,Ruth Eleanor ,00000000
> Coulianos,Theodore T ,00000000
> Clemen,Jacqueline Barbara ,00000000
> Martinez Jr,Bartolo ,00000000
> Conocchioli,Victor Renald ,00000000
> Church,Philip C ,00000000
> Crabbe,Victor Emmanuel Kweimensah ,00000000
>
> ---------------------------------------------------------------------------------------------------------
>
> Why is it still allocating 50 spaces ( the field is a varchar2(50) ) even though I specified RTRIM?
>
> What am I missing?
>
> Thanks,
>
Can't say without seeing the data. But the first thing I'd do is stop using RTRIM and use TRIM.
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri Aug 15 2003 - 11:09:23 CDT