CODEWITHSUNDEEP
xmloracle-database
Abel Morelos
Abel Morelos

Reputation: 1248

Edit XML stored as CLOB in an Oracle database

I have a column which is a CLOB that contains a large XML document. Let's say that from my application a single node in the XML data is edited, is it possible I could update the CLOB without rewriting all the text stored in the database?

I am aware i could do something like that if I used XMLType instead of CLOB, but I cannot change the data type in the database.

Thank you in advance.

Upvotes: 1

Views: 916

Answers (1)

Jon Heller
Jon Heller

Reputation: 36807

If you're on 11g, and the CLOB is a SECUREFILE, you can use FRAGMENT_REPLACE.

Upvotes: 1

Related Questions