How to trim the carriage return?
From: Tony Lai <tonylai_at_consultant.com>
Date: Tue, 3 Apr 2001 00:27:11 +0800
Message-ID: <9ackcs$g0k2_at_imsp212.netvigator.com>
Date: Tue, 3 Apr 2001 00:27:11 +0800
Message-ID: <9ackcs$g0k2_at_imsp212.netvigator.com>
Dear all,
In my Oracle 7 database, there is varchar2 column where the data consist of
carriage return. Now, if I want to extract that column with all the
carriage return replaced by a space, what should I do to accomplish that?
Any idea follow-up here or email to me are very much appreciated
Thanks alot...
--
Best Regards,
Tony Lai
Email : tonylai_at_consultant.com
Mobile Tel. No. : 6018-0411
Received on Mon Apr 02 2001 - 18:27:11 CEST