How to generate XSD file (XML Schmema defination file) from SQLX Query
Hello -
I've following SQLX query that we use to generate XML document, but our external systems wants xml schema definition (xsd) as well.
How can we do that?
Appreciate any help
SELECT
XMLElement ("Maharaj",
XMLAGG(
XMLELEMENT ("Employee",
/* XMLAttributes('http://www.oracle.com/emp_simple.xsd' AS "xmlns",
'http://www.w3.org/2001/XMLSchema-instance' AS "xmlns:xsi",
'http://www.oracle.com/emp_simple.xsd
http://www.oracle.com/emp_simple.xsd'
AS "xsi:schemaLocation"),*/
XMLForest(e.employee_id AS "EmployeeId",
e.last_name AS "Name",
e.job_id AS "Job",
e.manager_id AS "Manager",
e.hire_date AS "HireDate",
I've following SQLX query that we use to generate XML document, but our external systems wants xml schema definition (xsd) as well.
How can we do that?
Appreciate any help
SELECT
XMLElement ("Maharaj",
XMLAGG(
XMLELEMENT ("Employee",
/* XMLAttributes('http://www.oracle.com/emp_simple.xsd' AS "xmlns",
'http://www.w3.org/2001/XMLSchema-instance' AS "xmlns:xsi",
'http://www.oracle.com/emp_simple.xsd
http://www.oracle.com/emp_simple.xsd'
AS "xsi:schemaLocation"),*/
XMLForest(e.employee_id AS "EmployeeId",
e.last_name AS "Name",
e.job_id AS "Job",
e.manager_id AS "Manager",
e.hire_date AS "HireDate",
0