Re: SOS --- SQL question
From: Karla Johnson <ab803_at_lafn.org>
Date: 1995/12/18
Message-ID: <1995Dec18.165127.25614_at_lafn.org>#1/1
Date: 1995/12/18
Message-ID: <1995Dec18.165127.25614_at_lafn.org>#1/1
In a previous article, ddhond_at_ix.netcom.com (Dinar Dhond) says:
> I am trying to create a comma-delimited file using SQLPLUS, I have set
>linesize to 255 characters, but I am getting a lot of blank spaces at
>the end of the record. Is there any way to eliminate those blank
>spaces.
>ddhond_at_ix.netcom.com
Apply the Oracle RTRIM function to your string before storing it. In other words, if you build your text string using the variable MY_STRING, then RTRIM(MY_STRING) will whack off the trailing blanks.
Karla Johnson
-- +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+= Karla Johnson | Internet: karjohn_at_kincyb.com S/W Engr., Informax Data Systems | or ab803_at_lafn.org Los Angeles, California | Standard disclaimers, ad nauseamReceived on Mon Dec 18 1995 - 00:00:00 CET