Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> how to relace tokens in a CLOB filed
Hi,
I am new to Oracle. I really need your help:
I need to manuplate some data which has CLOB data type. I need to look through each CLOB and replace all the tokens say "_CEE_" with a new line return, and update or create a new table with the new value. I know i can use DBMS_LOB.INSTR to find the occurrences of the tokens, but i am not quite sure about the sytax to loop through the clob string and do the substitute.
Thank you in advance!
hbz123
-- Posted via http://dbforums.comReceived on Tue Dec 17 2002 - 16:09:00 CST