SQL developer

-- Use this template to structure your SCRIPT file -- remember that lines that begin with two dashes -- are comment lines -- I have provided liberal comments in the following to explain the template, please remove the comments before submission -- to create a CLEAN file -- -- general purpose PL statements to set the environment for the spooled output set echo off; set linesize 86; set pagesize 30; -- CLEAR COLUMNS; -- set all your column formatting statements here -- and as you build your queries -- anything that needs formatting can be coded in this section -- Review the Formatting Output in slide deck #6 COLUMN col1CurrencyData HEADING 'Column Heading' FORMAT $99,999.99; COLUMN col2Text/CharData HEADING 'Column Heading' FORMAT A10 TRUNC; COLUMN col3GeneralNumberData HEADING 'Column Heading' FORMAT 999.9; -- -- spool the result sets to a single output file spool h:\KeefeA6Spool.txt -- -- then for each query in the problem set..... -- make a heading to identify the query number (replacing my name with yours) ---------------------------------------------------- TTITLE LEFT '***** YourName SQL for A6.Q01 ****' BTITLE 'End of Q01' SELECT * from table...; ----------------------------------------------------- TTITLE LEFT '***** Keefe SQL for A6.Q02 ****' BTITLE 'End of Q02' SELECT * from table...; ----------------------------------------------------- - --repeat this pattern for all 12 queries - ---------------------------------------------------- TTITLE LEFT '***** YourName SQL for A6.Q12 ****' BTITLE 'End of Q12' SELECT * from table...; ---------------------------------------------------- -- the some final PL statements to clear the environment and close the spool file TTITLE OFF; BTITLE OFF; CLEAR COLUMNS; spool off;