SQL Server – Is it possible to update data inside a CLOB using SQL?

Posted onAuthorHeelpBook

--> (Word) --> (PDF) --> (Epub) --> (Text)
--> (XML) --> (OpenOffice) --> (XPS)
This article has been published [fromdate]
[readtime]

CLOB, short for "Character Large OBject", is a data type used to store and retrieve large amounts of text data in character format. A CLOB can store up to 128 terabytes of character data in the database.

SCENARIO

I have a table having one clob column which has XML data in it. say i want to replace XYZ with ABC in CLOB column. Is it possible using sqlplus / T-SQL query?

SOLUTION

select * from [tables]
update [tables] set [field] = replace([field],'xml string', 'xml string modiefied')
select * from [tables]
SOURCE

LINK (Stackoverflow.com)

LANGUAGE
ENGLISH