Subqueries, Reporting, and User-Access Control in Oracle9i
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
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 (hours)
2.7
Lesson ObjectivesSubqueries, 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