Introduction to Oracle9i: SQL PL/SQL, and SQL*Plus: Course

This course is no longer included in our schedule. It may still be available as a closed course, or there may be a more up to date alternative. Please contact a member of our sales team (Email: or Call: 0118 979 4000) for further advice.

Course Overview

This course has been retired. View the schedule of current Oracle Courses

This course introduces students to data server technology and explores the concepts of relational databases, the SQL*Plus interface tool, and the powerful SQL and PL/SQL programming languages. Students will learn and practice how to create and maintain database objects. The students will also learn to store, retrieve, and manipulate data. Finally, the students will learn how to create PL/SQL blocks of application code that can be used in Oracle® forms, reports, and other Oracle applications. This course will help the student to prepare for Oracle's exam, Introduction to Oracle9i SQL (1ZO-007).


Before taking this course, students should have taken the Introduction to Oracle9i course or have equivalent knowledge.

Topics covered

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus

SQL*Plus Commands

Filtering and Sorting Data

SQL Functions

Working with Multiple Tables

Tables and Constraints

Other Database Schema Objects

Building PL/SQL Blocks

PL/SQL Control Structures


Exception Handling

Procedures and Functions

Oracle Packages

Oracle Triggers

PL/SQL Collections

Tables Used in the Course

Course ID: PTR418