Script output to file when using SQL-Developer

user_2965 0
Viewed 66611

I have a select query producing a big output and I want to execute it in sqldeveloper, and get all the results into a file.

Sql-developer does not allow a result bigger than 5000 lines, and I have 100 000 lines to fetch...

I know i could use SQL+, but let's assume I want to do this in sqldeveloper.

oracle-sqldeveloper scripting file
4 Answers

Mike G answer will work if you only want the output of a single statement.

However, if you want the output of a whole sql script with several statements, SQL*Plus reports, and some other output formats, you can use the spool command the same way as it is used in SQL*Plus.

user_26576500
Related