Oracle:Section7

From mi-linux
Revision as of 18:26, 8 March 2016 by Cm1958 (talk | contribs) (Created page with " == 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 'Comp...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search


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 Salesmen 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.
Retrieved from "https://mi-linux.wlv.ac.uk/wiki/index.php?title=Oracle:Section7&oldid=8942"