Re: Oracle reports question?

From: TurkBear <johng_at_mm.com>
Date: Wed, 20 May 1998 14:33:06 GMT
Message-ID: <3564e8fd.2893360@news2.mm.com>

iancrozier_at_aol.com (Iancrozier) wrote:

>I am trying to output an Oracle report using sqlplus. I want the output to look
>like e.g. :
>
>ABCD,123,efg,456
>ABCDE,234,ghij,7893
>
>What I get is:
>ABCD ,123,efg ,456
>ABCDE,234,ghij,7893
>
>Note the extra spaces after ABCD and efg. I've tried rtrim, but that doesn't
>work, because there aren't really any spaces in the database.
>Any suggestions?
>TIA
>

Since rtrim doesn't work you may need to do this less elegant method ( assuming the fields are Varchar2 )
select substr(field1,1,length(field1) f1,etc....

I don't have a test field to try this against, but it should work.... Received on Wed May 20 1998 - 09:33:06 CDT