diff options
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 |