blob: 243936a68f835dc546d3aa0d6341af67c69d7467 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
set pages 0
set long 9999999
set head off
spool /tmp/export-kapv.xml
select dbms_xmlgen.getxml('select * from Adressen') from dual;
select dbms_xmlgen.getxml('select * from Kunden') from dual;
select dbms_xmlgen.getxml('select * from Produktlager') from dual;
select dbms_xmlgen.getxml('select * from Kunden_Profil') from dual;
select dbms_xmlgen.getxml('select * from Auftrag') from dual;
select dbms_xmlgen.getxml('select * from Rechnungsdaten') from dual;
select dbms_xmlgen.getxml('select * from Auftrag_hat_Positionen') from dual;
select dbms_xmlgen.getxml('select * from Kunde_hat_Adresse') from dual;
select dbms_xmlgen.getxml('select * from Vorlieben') from dual;
select dbms_xmlgen.getxml('select * from Kunde_hat_Vorlieben') from dual;
select dbms_xmlgen.getxml('select * from Zu_Vorlieben_gehoeren_Produkte') from dual;
spool off
|