Oracle Introduction: Subqueries, Reports, and DML


Overview/Description
To explain the types of subquery, how to produce reports, and to introduce DML statements

Target Audience
Trainee database administrators and application developers

Prerequisites
Previous courses in this curriculum

Expected Duration
4 Hours

Objectives:

Oracle Introduction: Subqueries, Reports, and DML

  • To explain single-row subqueries, multiple-row subqueries, and multiple-column subqueries
  • To explain how to use SQL*Plus commands to produce readable reports
  • To explain how to manipulate data in a table using various DML statements
  • To describe how to control database transactions

  • Course Number: SQPL03E