Subqueries, Reporting, and User-Access Control in Oracle9i

Overview/Description
To describe the use of subqueries, reporting, and user-access control in an Oracle9i database

Target Audience
Junior database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration
160 Minutes

Objectives:

Subqueries, Reporting, and User-Access Control in Oracle9i

  • describe and define subqueries and to write single-row and multiple-row subqueries for an Oracle database.
  • use single-row subqueries in an Oracle database.
  • use the advanced functionality of subqueries in an Oracle9i database.
  • explain the concept of a hierarchical query and to explain how to create a tree-structure report in an Oracle9i database.
  • explain how to produce reports using iSQL*Plus in an Oracle9i database.
  • produce reports using iSQL*Plus in an Oracle9i database.
  • describe how to control user access to an Oracle database.
  • use roles and privileges to control user access to an Oracle database.


    • Course Number: 66925_eng