Updating xml clob in oracle
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.