Lo que hay que saber sobre SQLX

Ejemplos de XML ORACLE:

--      SYS_XMLGEN:

SELECT SYS_XMLGEN(email)        

    FROM employees

    WHERE employee_id = 205;

--      SYS_XMLAGG:

SELECT SYS_XMLAGG(SYS_XMLGEN(last_name)) XMLAGG

   FROM employees

   WHERE last_name LIKE 'R%'

   ORDER BY xmlagg;

--      XMLELEMENT:

SELECT XMLELEMENT("Emp", XMLELEMENT("Name", 

   e.job_id||' '||e.last_name),

   XMLELEMENT("Hiredate", e.hire_date)) as "Result"

   FROM employees e WHERE employee_id > 200;

--      XMLATTRIBUTES:

SELECT XMLELEMENT("Emp", XMLATTRIBUTES(e.employee_id, e.last_name),

   XMLELEMENT("Dept", XMLATTRIBUTES(e.department_id,

   (SELECT d.department_name FROM departments d

   WHERE d.department_id = e.department_id) as "Dept_name")),

   XMLELEMENT("salary", e.salary),

   XMLELEMENT("Hiredate", e.hire_date)) AS "Emp Element"

   FROM employees e

   WHERE employee_id = 205;

--      XMLFOREST:

SELECT XMLELEMENT("Emp", 

   XMLFOREST(e.employee_id, e.last_name, e.salary))

   "Emp Element"

   FROM employees e WHERE employee_id = 204;

--      XMLCONCAT:

SELECT XMLCONCAT(XMLELEMENT("First", e.first_name),

   XMLELEMENT("Last", e.last_name)) AS "Result"

   FROM employees e

   WHERE e.employee_id > 202;

--      XMLAGG:

SELECT XMLELEMENT("Department",

   XMLAGG(XMLELEMENT("Employee", e.job_id||' '||e.last_name)

   ORDER BY last_name))

   as "Dept_list"     

   FROM employees e

   WHERE e.department_id = 30;

--      XMLPI:

SELECT XMLPI(NAME "Order analysisComp", 'imported, reconfigured, disassembled')

   AS "XMLPI" FROM DUAL;

--      XMLCOMMENT:

SELECT XMLCOMMENT('OrderAnalysisComp imported, reconfigured, disassembled')

   AS "XMLCOMMENT" FROM DUAL;

--   XMLROOT:

SELECT XMLROOT ( XMLType('143598'), VERSION '1.0', STANDALONE YES)

   AS "XMLROOT" FROM DUAL;

--   XMLSERIALIZE:

SELECT XMLSERIALIZE(CONTENT XMLTYPE('Grandco'))

   FROM DUAL;

--   XMLCDATA:

SELECT XMLELEMENT("PurchaseOrder",

   XMLAttributes(dummy as "pono"),

   XMLCdata('

   ]>')) "XMLCData" FROM DUAL;