existsnode(myValue, '/ROWSET') : 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> select COUNT(*)
  2  from myTable d
  3  where existsnode(myValue, '/ROWSET') = 1
  4  /

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

1 row selected.

SQL>
SQL>
SQL> drop table myTable;

Table dropped.