XMLElement : xmlelement « XML « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. XML
  3. 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>








33.3.xmlelement
33.3.1.Use XMLELEMENT to convert column data to xml format
33.3.2.XMLElement
33.3.3.Create xml element with xmlelement function