|Oracle8i Application Developer's Guide - XML
Release 3 (8.1.7)
Part Number A86030-01
Using XML-SQL Utility (XSU), 21 of 26
The steps involved in using the XML-SQL Utility storage engine follow:
setUpdateColNamesfunction. The default is to insert values into all the columns.
For updates, the list of key columns must be supplied. Optionally the list of columns to update may also be supplied. In this case, the tags in the XML document matching the key column names will be used in the WHERE clause of the update statement and the tags matching the update column list will be used in the SET clause of the update statement.
For deletes the default is to create a WHERE clause to match all the tag values present in each ROW element of the document supplied. To override this behavior you can set the list of key columns. In this case only those tag values whose tag names match these columns will be used to identify the rows to delete (in effect used in the WHERE clause of the delete statement).
deleteXMLfunctions to insert, update and delete respectively.
Use the same examples as for the Java case,
OracleXMLSave class examples.