Oracle:Section7

From mi-linux
Revision as of 17:30, 8 March 2016 by Cm1958 (talk | contribs)
Jump to navigationJump to search

Main Page >> Oracle and SQL >> Workbook >> Section 7 answers


Exercise 7.1

7.1 Create a file which produces a report on Salesmen earning more than 3000. The report should have the following features:

  • it should be headed 'Computing Sales Report'
  • each page should have 'For Your Eyes Only' at the bottom of the report.
  • the output should be ordered by salary.
  • The SQL query file should be stored as U:\salesman.sql.
  • save the output of the query into a file U:\salary.txt.

SET TTITLE 'Computing Sales Report' SET BTITLE 'For Your Eyes Only' SET PAGESIZE 65

SPOOL u:\salary.txt SELECT * FROM EMP WHERE JOB = 'SALESMAN';

REM don't forget to switch everything off again SPOOL OFF TTITLE OFF BTITLE OFF