Extract returns a COLLECTION of values (a repeating node) : xpath « XML « Oracle PL / SQL






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

Extract returns a COLLECTION of values (a repeating 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> select extract(myValue, '/ROWSET/ROW/TABLE_T/COL_LIST/COL_LIST_ITEM/NAME')
  2  from myTable
  3  where extractvalue(myValue, '/ROWSET/ROW/TABLE_T/SCHEMA_OBJ/NAME') = 'T';

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.Find rows that contain the ROWSET/ROW node