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
PaulP