Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Removing carriage returns in text column in oracle table, in SQL

user1636556Jun 16 2011 — edited Jun 16 2011

Hi,

Would anyone know how to remove carriage returns within a text column in an Oracle table
using SQL. So far I have:

REPLACE(text_field,chr(13),' ')

but this is ignored.

(We are using db 10g (enterprise Edition Release 10.2.0.4.0) and SQL*Plus 10.2.0.1.0.

I would be very grateful for any help.

- Mark

This post has been answered by Dude! on Jun 16 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2011

Added on Jun 16 2011

#general-database-discussions

5 comments

41,028 views