How to write to a CSV file using Oracle SQL*Plus
SPOOL command The SPOOL command is unavailable in the browser-based SQL*Plus version, iSQL*Plus . To generate files while using iSQL*Plus, change the necessary preference settings to directly output to a file. This is accomplished using the SPOOL statement. While SPOOL is active , SQL*PLus will store the output of any query to the specified file. Therefore, the next command to enter is spool : spool filepath Skipping ahead slightly, after your query is inserted, you also need to halt spool so the file output is closed by using the spool off command: spool off Insert the query The last step after the settings are modified and spool is running is to insert your query. For our simple example, we’re outputting all books from our books table. SELECT title, author FROM authors; Don’t forget the semi-colon to close out your query statement, then enter the aforementioned spool off command. That’s it, you’ve generated a new text file with the results of your qu