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;
/
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With