diff options
| author | Benjamin Franzke <benjaminfranzke@googlemail.com> | 2013-01-26 18:49:51 +0100 |
|---|---|---|
| committer | Benjamin Franzke <benjaminfranzke@googlemail.com> | 2013-01-26 22:03:06 +0100 |
| commit | df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51 (patch) | |
| tree | af18982b5354d95900749b513f5387a2e8397fa9 /oracle-conversion/export-kapv.sql | |
| parent | 4eba780ed25ea4fbae8e032dc3510e1c083d0310 (diff) | |
| download | sqltutor-plugin-df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51.tar.gz sqltutor-plugin-df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51.tar.bz2 sqltutor-plugin-df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51.zip | |
begin oracle conversion toolset
Diffstat (limited to 'oracle-conversion/export-kapv.sql')
| -rw-r--r-- | oracle-conversion/export-kapv.sql | 17 |
1 files changed, 17 insertions, 0 deletions
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 |