Updating xml clob in oracle

09-Oct-2017 07:23

updating xml clob in oracle-13

oprah online dating

The COLUMNS clause is used to transform XML data into relational data.

Each of the entries in this clause defines a column with a column name and a SQL data type.

Sometimes you may want to fetch the text value of currently selected node item.

In below example we will select path /Employees/Employee/firstname.

In part one of “Generating XML from SQL and PL/SQL“, I explained how to generate XML from SQL.

In above query we defined two columns firstname and lastname that points to PATH firstname and lastname or selected XML node.