Find rows that contain the ROWSET/ROW node : xpath « XML « Oracle PL / SQL






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

Find rows that contain the ROWSET/ROW node

    
SQL> CREATE TABLE myTable
  2    (myID            NUMBER PRIMARY KEY,
  3     myValue     XMLTYPE )
  4     XMLTYPE myValue STORE AS CLOB
  5  /

Table created.



SQL>
SQL>
SQL> 
SQL> select myID
  2  from myTable
  3  where existsnode(myValue, '/ROWSET/ROW')  = 1
  4  /

no rows selected

SQL>
SQL>
SQL> drop table myTable;

Table dropped.

SQL>








Related examples in the same category

1.Use extract function and xpath function to retrieve xml element data
2.Use extract function to get xmltype data
3.XPath text() function
4.Oracle support XPath predicate expressions
5.Use the EXTRACT function and the following XPath:/emps/emp/interests/interest/
6.extract(doc, '/message/greeting/text()')
7.Extract returns a COLLECTION of values (a repeating node)