How to check for text node of an element in xmltype oracle <p>Using the following query,</p> <pre><code>SELECT * FROM sampletable WHERE XMLExists('/books/book[@max="30"]' passing XMLCOLUMN); </code></pre> <p>But I want to know , how to check for the plain text content of an element, like</p> <pre><code>SELECT * FROM sampletable WHERE XMLExists('/books/book="Content"' passing XMLCOLUMN); </code></pre>