Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle reports question?
johng_at_mm.com (TurkBear) wrote:
>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....
>
>
Oops, I missed a ) - substr(field1,1,length(field1)) -
Sorry, Received on Wed May 20 1998 - 12:29:29 CDT