Applying It |
Independent Exercise 1:
- Build a master/detail report using Emp and DEPT, showing each department (deptno and dname) followed by an ordered list of employee name, title, and salary, with a subtotal by department on salary and a report total of all salaries.
Independent Exercise 2:
- Build the same report as Exercise 1 using SQL*Plus.
Independent Exercise 3:
- Create HTML output from Exercise 1 and add the Metro Motors Logo to the top of each report, add “Contact us” with an e-mail hyperlink to the bottom of each report.
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.