ODI Real time Scenario's and Interview Questions
Pages
(Move to ...)
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
‹
›
Home
View web version
No comments:
Post a Comment