SQL Developer – save result form many SELECT

I have to run many select from one script like :

SELECT * FROM table_01;
SELECT * FROM table_02;
..
SELECT * FROM table_xx;

How to save result for all SELECT in SQL Developer ?

Answer

A simple option is to spool result into a file. Here’s how: