Save to file

[netraider]

Hi - New to PL/SQL Developer. Currently trying to run a query so the results can be save to file but I received the following error:

ORA-00900: invalid SQL statement

Been running this query for a while in other platforms without any issues. Is there another way in PL/SQL Developer to save the results to file. Query below

spool c:\temp\myoutputfile.csv
select * from mytable;

spool off;

Many Thanks.

 

[Claus Pedersen]

Sounds to like you are trying to run the script in SQL window?
Try running the script in a command window. This is the PL/SQL Developer equivalent to a SQL*Plus command prompt.

If you run the select "select * from mytable" in an SQL window and right-click in the result grid, you also have some options to save the results to file, Excel, copy to clipboard etc.

 

[netraider]

Thanks so much. I the query from the command window and it works great.

Thanks.