blob: 934f08a87a4159158ae4370032158dc29bf63143 (
plain)
1
2
3
4
5
6
7
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
|