Friday, December 30, 2016

Extract Content in CLOB datatype (XML) in Oracle

Scripts:



Query:

SELECT
   XMLTYPE(CCS.xml).EXTRACT('//price/text()').getStringVal() as PRICE
FROM
   CLOB_CONTENT_SEARCH CCS;

Output:



No comments:

Post a Comment