Oracle 9i introduced a new datatype – XMLType- specifically designed for handling XML naively in the database. However, we may find we have a database that stores XML directly in a CLOB/NCLOB datatype (either because of legacy data, or because
Querying XML CLOB Data Directly in Oracle
