HEELPBOOK - SQL Server - Is it possible to update data inside a CLOB using SQL? ################

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]



############ ARTICLE INFO #############

Article Month: March
Article Date: 22/03/2012
Permalink: http://heelpbook.altervista.org/2012/sql-server-is-it-possbile-to-update-data-inside-a-clob-using-sql/
Source: http://stackoverflow.com/questions/3139905/is-it-possbile-to-update-data-inside-a-clob-using-sql
Language: English

View more articles on: http://www.heelpbook.net/
Follow us on Facebook: http://it-it.facebook.com/pages/HeelpBook/100790870008832
Follow us on Twitter: https://twitter.com/#!/HeelpBook
Follow us on RSS Feed: http://feeds.feedburner.com/Heelpbook