SQL & PL/SQL

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!

Find and Replace data in CLOB (XML data)

SKaviJan 27 2009 — edited Jan 27 2009

Hi guys,

I need you help.
I have challenge where I have to popluate one of CLOB column from a table lets say table MESSAGE and column is MSG CLOB datatype.
Data will look like this.
<Message AtcitFlag = "Y"
< Sri id = "102" Msg = " Hello how are you "
</Sri>
<Sri id = "103 Msg = "doing?"
</Sri>
</Message>

I will have to read the ID value and from a lookup table then I will be replacing the new value for ID ..
in case of 102 lets say I will have to replace that with 20002. ans so on...

Please help me.. I guess I have to use ORACLE package DBMS_LOB.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 24 2009

Added on Jan 27 2009

8 comments

4,688 views