oracle xmltype使用,如何在oracle xmltype里添加属性？用oracle 自带函数？求解答

怎么在oracle xmltype里添加属性？用oracle 自带函数？求解答

如题 在线等答案，麻烦各位

------解决方案--------------------

使用insertchildxml(xmltype_column, new_attribute, new_attribute_name);

SQL> CREATE TABLE xml_test(xmldoc sys.xmltype);

Table created

SQL> INSERT INTO xml_test VALUES(sys.xmlType.createXML('abc'));

1 row inserted

SQL> select i.xmldoc.extract('//name/a[@id=1]/@attribute1').getStringVal() from xml_test i;

I.XMLDOC.EXTRACT('//NAME/A[@ID

--------------------------------------------------------------------------------

attribute1 value

SQL> update xml_test set xmldoc=insertchildxml(xmldoc,'//name/a[@id=1]','@new_attribute','new attribute value');

1 row updated

SQL> select i.xmldoc.extract('//name/a[@id=1]/@attribute1').getStringVal(), i.xmldoc.extract('//name/a[@id=1]/@new_attribute').getStringVal() from xml_test i;

I.XMLDOC.EXTRACT('//NAME/A[@ID                                                   I.XMLDOC.EXTRACT('//NAME/A[@ID

-------------------------------------------------------------------------------- --------------------------------------------------------------------------------

attribute1 value                                                                 new attribute value

SQL> drop table xml_test;

Table dropped

SQL>