Find rows that contain the ROWSET/ROW node : existsNode « XML « Oracle PL/SQL Tutorial

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

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

Table created.



SQL>
SQL>
SQL> 
SQL> select myID
  2  from myTable
  3  where existsnode(myValue, '/ROWSET/ROW')  = 1
  4  /

no rows selected

SQL>
SQL>
SQL> drop table myTable;

Table dropped.

SQL>