Export multiple csv files using sql

From a worksheet, using Run Script (F5), you can do something like this if connected to the seeded HR schema:

spool C:\Temp\countries.lst

select /*csv*/ * from countries;

spool off

 

spool C:\Temp\departments.lst

select /*csv*/ * from departments;

spool off

 

spool c:\Temp\employees.lst

select /*csv*/ * from employees;

spool off

Hope this helps,

Gary