ODI Real time Scenario's and Interview Questions
Pages
Introduction
ODI Architecture
Data Warehouse Concepts
ODI 12c Material
ODI Interview Questions
SQL interview questions
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment