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>