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






  1. Oracle PL/SQL Tutorial
  2. XML
  3. extractvalue
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>








33.5.extractvalue
33.5.1.Demo EXTRACTVALUE use in the WHERE clause
33.5.2.Extract can be used in WHERE clause to search xml document
33.5.3.Extract returns a COLLECTION of values (a repeating node)