Practice

1: Create a report for all of the departments. The report should have the following specifications:
  • The employees’ names, employment date, current position, wages, and tool purchases.

  • Tool information should consist of purchase date, tool name, and tool cost.

  • The report should be landscape (132 characters wide).

  • Compute the total cost of each employee’s tool purchases.

  • Use a custom label for the total cost subtotal.

  • Display the current date in the title.

  • Create an appropriate title for the report.

  • Each department’s records should begin on a new page.

  • Display the page number on the lower right of each page.

  • Suppress duplicate values.

  • Create custom headings for all columns.

Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts 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.