Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / XML

 

XMLElement

SQL> SQL> SELECT XMLElement("text",XMLAttributes(2 AS "x",2 AS "y"),2) FROM dual; XMLELEMENT("TEXT",XMLATTRIBUTES(2AS"X",2AS"Y"),2) -------------------------------------------------------------------------------- <text x="2" y="2">2</text>