Replacing values in CLOB column [message #38006] |
Wed, 13 March 2002 08:10 |
Mike Oakes
Messages: 25 Registered: December 2000
|
Junior Member |
|
|
Hello is it possible for me to replace all instances of "^" with a line feed. I am able to do this with char types but when i try the following command with clob data types, I receive an error "inconsistent datatypes". I tried using TO_CHAR but to no avail. ANy help would be appreciated.
Update Table1 set column1 = replace(COLUMN1,'^',chr(010));
I receive error ORA-00932: inconsistent datatypes. Column1 is a clob data type. Is there any way this can be done.
|
|
|
|
|
|