How to trim the carriage return
From: Tony Lai <tonylai_at_consultant.com>
Date: Sat, 31 Mar 2001 21:56:12 +0800
Message-ID: <9ackcr$g0k1_at_imsp212.netvigator.com>
Date: Sat, 31 Mar 2001 21:56:12 +0800
Message-ID: <9ackcr$g0k1_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.comReceived on Sat Mar 31 2001 - 15:56:12 CEST