Re: SOS --- SQL question
Date: 1995/12/13
Message-ID: <4am4j9$ehv_at_inet-nntp-gw-1.us.oracle.com>#1/1
ddhond_at_ix.netcom.com (Dinar Dhond ) writes:
|> Hi,
|>
|> 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.
|>
|> Any help would be greatly appreciated
|>
|> Dinar
|>
|> ddhond_at_ix.netcom.com
SQL*Plus has the the command
SET TRIMOUT ON
to remove trailing blanks when displaying to a terminal.
If you are spooling to a file, then you have you can use
SET TRIMSPOOL ON
But I think it's only available in SQL*Plus V3.2 and higher.
Before that, you would have to use 'sed' or whatever its
equivalent is on non-Unix platforms.
Hope this helps.
Roderick
Received on Wed Dec 13 1995 - 00:00:00 CET