When your SQL query is ready, you can run the query immediately or you can add a title, change its options, limit its output, and so on, to make the report look better. See Viewing the SQL Code, ...
I am trying to output several large tables (10's of MB) from SQL PLus over Citrix and it's really slow. Code: set pagesize 0 set autotrace off set flush off set termout off spool l:\spool\acctact.txt ...