Oracle XML tutorial - XMLTable, SQL, XPath select query

Hi! In this tutorial I will explain XPath and XMLTable operators which allow you to create a table from XMLType. I will demonstrate how to use Xpath and show how you can work with XML stores as CLOB column in database. What's more I will show how to compare dates using XPath.

[Srigurumurthy]

Quick question: what if i am trying to include the data in the XML in the select statement. For example, for whatever where condition, i need to pull the data in a specific XML node/element/etc.

SELECT
XML data
FROM table
WHERE conditions

[tatavioleta]

Hi there! Can offer me some help? Im doing a very similar query, but it seems like my clob columns is too long. The error says that the string is longer than 4000 characters... how can I solve it?