Subqueries and Hierarchical Queries in Oracle Database 10g


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
To demonstrate how to use subqueries and hierarchical queries in Oracle 10g

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
2.2

Lesson Objectives

Subqueries and Hierarchical Queries in Oracle Database 10g

  • write single-row and multiple-row subqueries.
  • use subqueries to solve queries in an Oracle database.
  • write multiple-column, scalar, and correlated subqueries.
  • use the EXISTS, UPDATE, DELETE, and WITH clauses.
  • solve problems using multiple-column, correlated, and scalar subqueries and using the WITH clause.
  • use hierarchical queries to create tree-structured reports.
  • write hierarchical queries.

    • Course Number:
    223292_eng