SQL> CREATE TABLE myTable
2 (myID NUMBER PRIMARY KEY,
3 myValue XMLTYPE )
4 XMLTYPE myValue STORE AS CLOB
5 /
Table created.
SQL>
SQL>
SQL> select count(extract(myValue,'/ROWSET') )
2 AS count
3 from myTable;
COUNT
----------
0
1 row selected.
SQL>
SQL> drop table myTable;
Table dropped.
SQL>