existsnode(myValue, '/ROWSET') : ExistsNode « XML « Oracle PL / SQL






  1. Oracle PL / SQL
  2. XML
  3. ExistsNode

existsnode(myValue, '/ROWSET')

  

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.








Related examples in the same category

1.Oracle XML function ExistsNode.
2.Count(*) and existsnode()
3.existsnode and where clause