Forum Stats

  • 3,741,291 Users
  • 2,248,405 Discussions


How to export large data sets from SQL Developer without running the SQL query twice

PaulP Member Posts: 735 Bronze Badge
edited Oct 8, 2020 7:33AM in SQL Developer

I regularly use SQL Developer to extract large delimited text files from the data base, up to 4 million rows. I first run the SQL and it takes quite a while to return the first set of records of a de-normalized version of the data via multiple joins, that appears in the results pane. I then have to right click on the results and choose to export them to an external file. The SQL needs to run a second time. Its it possible in SQL Developer to somehow run the extract by executing the script only once?

thanks in advance



Sign In or Register to comment.