From df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51 Mon Sep 17 00:00:00 2001 From: Benjamin Franzke Date: Sat, 26 Jan 2013 18:49:51 +0100 Subject: begin oracle conversion toolset --- oracle-conversion/export-kapv.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 oracle-conversion/export-kapv.sql (limited to 'oracle-conversion/export-kapv.sql') diff --git a/oracle-conversion/export-kapv.sql b/oracle-conversion/export-kapv.sql new file mode 100644 index 0000000..243936a --- /dev/null +++ b/oracle-conversion/export-kapv.sql @@ -0,0 +1,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 -- cgit