Skip to Main Content
Forums

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!

Update a XML field in blob column

User_R0EA7Jun 18 2019 — edited Jun 19 2019

Hi All,

I have a requirement to update a XML element value in blob column of oracle database. Could you please let me know the query ?

Below are the screenshots.

pastedImage_1.png

I am running a select query to view the contents of blob column. It contains XML payload.

I have a requirement to update the element status(highlighted below) to new string 'Approved'.

pastedImage_0.png

Thanks,

Amith
Comments
Post Details
Added on Jun 18 2019
#plsql
5 comments
2,586 views