Call existsNode() function from xmltype data : existsNode « XML « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. XML
3. existsNode

SQL>
SQL> CREATE TABLE myTable
  2    (myID            NUMBER PRIMARY KEY,
  3     myValue         XMLTYPE
  4  )XMLTYPE myValue STORE AS CLOB
  5  /

Table created.

SQL>
SQL> select COUNT(*)
  2  from myTable d
  3  where d.myValue.existsNode('/ROWSET') = 1
  4  /

  COUNT(*)
----------
         0

1 row selected.

SQL> drop table myTable;

Table dropped.

SQL>
SQL>