Call existsNode() function from xmltype data
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>