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


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 nauseam
Received on Mon Dec 18 1995 - 00:00:00 CET

Original text of this message