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>

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

This message: [ Message body ]
Next message: Mike Moore: "Re: Full Join"
Previous message: Mike Moore: "Re: Full Join"
Next in thread: Mark Malakanov: "Re: How to trim the carriage return?"
Reply: Scott Mattes: "Re: How to trim the carriage return"
Reply: Roelof K. Salomons: "Re: How to trim the carriage return"
Reply: Mark Malakanov: "Re: How to trim the carriage return?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message