1 Reply Latest reply on Oct 22, 2014 9:20 PM by Gary Graham-Oracle

    Export multiple csv files using sql

    906603

      Is there a way to export multiple csv files using different SQL's in one go?

        • 1. Re: Export multiple csv files using sql
          Gary Graham-Oracle

          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