Update CLOB column [message #336075] |
Thu, 24 July 2008 13:07  |
ibuchatting
Messages: 2 Registered: July 2008 Location: Chennai
|
Junior Member |
|
|
Hi,
I have CLOB column in a table which contains carriage return (\r) and enter (\n) characters. I have to replace these characters by a space.
Please help me in doing this.
Thanks in advance
|
|
|
|
|
Re: Update CLOB column [message #336083 is a reply to message #336079] |
Thu, 24 July 2008 13:24   |
ibuchatting
Messages: 2 Registered: July 2008 Location: Chennai
|
Junior Member |
|
|
Dear Michel,
Thanks for your response.
I thought i need to use DBMS_LOB package. Since I am not comfortable in this i had raised request here.
Please confirm whether the following update statement will do,
UPDATE Table_name SET Column_Name= REPLACE(REPLACE(Column_Name,'\r',' '),'\n',' ');
Thanks in advance.
|
|
|
|
|