XML file generation [message #663574] |
Thu, 08 June 2017 12:36 |
|
ORA2015
Messages: 49 Registered: March 2015
|
Member |
|
|
Hello,
I have to submit a document in XML format. I was also given a schema to work with but not sure how to apply it.
Our data is stored in an oracle database and sql queries are usually done on PL/SQL developer to retrieve output in excel format.
However i need output in xml format. How do i do this?
I understand that i can include items like the below..but how do i get the output in xml and how do i integrate the schema provided.
SELECT XMLElement( "DEPARTMENT"
, department_name
)
FROM departments
WHERE department_id IN (10, 20);
Your assistance will be greatly appreciated.
|
|
|