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-lessons.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-lessons.sql')
-rw-r--r-- | oracle-conversion/export-lessons.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/oracle-conversion/export-lessons.sql b/oracle-conversion/export-lessons.sql new file mode 100644 index 0000000..934f08a --- /dev/null +++ b/oracle-conversion/export-lessons.sql @@ -0,0 +1,8 @@ +set pages 0 +set long 9999999 +set head off + +spool /tmp/export-lesson.xml +select dbms_xmlgen.getxml('select * from lessons') from dual; +select dbms_xmlgen.getxml('select * from lesson_order') from dual; +spool off |