Without the text() operator, returns node name + text value
SQL> CREATE TABLE myTable(
2 id NUMBER PRIMARY KEY
3 ,doc XMLType NOT NULL
4 )
5 XMLTYPE doc STORE AS CLOB
6 /
Table created.
SQL>
SQL>
SQL> select extract(doc, '/message/greeting')
2 from myTable;
no rows selected
SQL>
SQL>
SQL> drop table myTable;
Table dropped.
Related examples in the same category