Oracle access to XML-formatted data

Most of the examples on the oracle|xml| data network are wrong

The key to
is to set the label for the row to RowTag, such as:


<?xml version= ' 1.0 '?>


<root>


<record>


<column1>aaaa</column1>


<column2>bbbb</column2>


</record>


</root>


, if your watch is
,

Table AAA


(


AAA varchar (20),


BBB varchar (20)


)





so to specify which label is the record to begin with. We're going to specify
here.

Save.setrowtag ("Record");


generally the XML obtained from the original table is fixed with Rowsettag and RowTag. Name is


Rowset and Rwo


For example:


<?xml version= ' 1.0 '?>


<ROWSET>


<row num= "1" >


<column1>aaaa</column1>


<column2>bbbb</column2>


</ROW>


</ROWSET>


but you specify the name you want before you get the string:


Qry.setrowsettag ("tablename");


Qry.setrowtag ("Recordname");


, this will get
.

<?xml version= ' 1.0 '?>


<TABLENAME>


<recordname num= "1" >


<column1>aaaa</column1>


<column2>bbbb</column2>


</RECORDNAME>


</TABLENAME>


So when you write it, just specify the corresponding label as RowTag:


Save.setrowtag ("Recordname");


save.insertxml (XML); OK.








In addition, it is particularly noteworthy that XML is case-sensitive, and that your recordname and recordname are two different tag