SQL> set pagesize 37
SQL> set linesize 60
SQL> set feedback off
SQL> TTITLE 'EMPLOYEE&#124REPORT'
SQL> BTITLE 'CONFIDENTIAL'
SQL> BREAK ON JOB
SQL> COLUMN JOB HEADING 'JOB&#124CATEGORY' FORMAT A15
SQL> COLUMN ENAME HEADING 'EMPLOYEE' FORMAT A15
SQL> COLUMN SAL HEADING 'SALARY' FORMAT $99,999.99
SQL> REM ** INSERT SELECT STATEMENT
SQL> select job,ename,sal from emp where sal<3000
  2  ORDER BY JOB,ENAME
  3  /
  
Wed Jun 25                                         page    1
                          EMPLOYEE
                           REPORT
  
JOB
CATEGORY        EMPLOYEE             SALARY
--------------- --------------- -----------
CLERK           ADAMS             $1,100.00
                JAMES               $950.00
                MILLER            $1,300.00
                SMITH               $800.00
MANAGER         BLAKE             $2,850.00
                CLARK             $2,450.00
                JONES             $2,975.00
SALESMAN        ALLEN             $1,600.00
                MARTIN            $1,250.00
                TURNER            $1,500.00
                WARD              $1,250.00
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
                        CONFIDENTIAL
SQL> SET FEEDBACK ON
SQL> REM CLEAR ALL FORMATTING COMMANDS ..
SQL>