Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Export XML (11g)
Export XML [message #667391] Tue, 26 December 2017 06:43 Go to previous message
marcinsgdz
Messages: 14
Registered: December 2017
Junior Member
Hellow

COL KONTA FORMAT a20000; 
spool /home/oracle/Desktop/PLIKI_XML/export6.xml;
select dbms_xmlquery.getxml('
SELECT XMLELEMENT ("USER",
                   XMLELEMENT ("IMIE", IMIE),
                   XMLELEMENT ("NAZWISKO", NAZWISKO),
                   XMLELEMENT ("DZIAL", DZIAL),
           XMLELEMENT ("LOGIN", LOGIN),
                   XMLELEMENT ("TYP", TYP),
           XMLELEMENT ("EMAIL", EMAIL),
           XMLELEMENT ("DATA_NADANIA", DATA_NADANIA),
XMLELEMENT ("DATA_COFNIECIA", DATA_COFNIECIA)
) AS KONTA
FROM KONTA_AD JOIN UPOWAZNIENIA ON
(KONTA_AD.NR_UPOWAZNIENIA=UPOWAZNIENIA.NR_UPOWAZNIENIA)
')
from dual;
spool off

And it only receives this in the xml file.

<?xml version = '1.0'?>
<rowset> <row num="1"> <konta> <user>

In addition, I have in the file the content of the inquiry - how to get rid of the machine?
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: persian calendar
Next Topic: Running ORDS standalone
Goto Forum:
  


Current Time: Fri Mar 29 07:01:26 CDT 2024