Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to convert oracle table data into separate xml file using store procedure

Tags:

I want to know how to convert table data into xml separate file. Whether I need to use UTL file concepts?. Below is the sample code. can any one help me to clear on this?

CREATE OR PROCEDURE PRC_INSDB_XML (Booking_date1 in date)
as 

begin

SELECT XMLElement("Employee", XMLForest(empno, ename, job, mgr, hiredate, sal, comm, deptno, gender)) AS "RESULT" FROM emp where Booking_date=Booking_date1 ;

end PRC_INSDB_XML;
/