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 ...
You can create a new SAS, DB2, or other database management system table from your output; see Creating New Tables for details You can save the SQL query to a catalog entry of type SQL. You can save ...