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
