From df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51 Mon Sep 17 00:00:00 2001
From: Benjamin Franzke <benjaminfranzke@googlemail.com>
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 

