[Oracle SQL] Parse XML From CLOB

Oracle SQL ile XML Parsing.

----------------------------------------------------------------------------

WITH ornek_xml AS

(SELECT '<manav><meyve>Elma</meyve></manav>' AS meyve_xml

  FROM   dual)

SELECT xmltype(ox.meyve_xml).extract('//meyve/text()').getstringval() AS extracted_meyve

FROM   ornek_xml ox;

----------------------------------------------------------------------------

Result:

EXTRACTED_MEYVE

Elma