Oracle support XPath predicate expressions : xpath « XML « Oracle PL / SQL






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

Oracle support XPath predicate expressions

   
SQL> CREATE TABLE myTable
  2  (id  NUMBER PRIMARY KEY
  3  ,doc XMLType NOT NULL)
  4  XMLTYPE doc STORE AS CLOB
  5  /

Table created.

SQL>
SQL>
SQL> 
SQL> update myTable
  2  set doc = updateXml( doc,'message[greeting="Hi"]/body/text()', 'test again')
  3  /

0 rows updated.

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.Use the EXTRACT function and the following XPath:/emps/emp/interests/interest/
5.extract(doc, '/message/greeting/text()')
6.Extract returns a COLLECTION of values (a repeating node)
7.Find rows that contain the ROWSET/ROW node