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.