Subqueries and Hierarchical Queries in Oracle Database 10g

This course is included in our On-demand training solution.

Overview

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

130 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?