Oracle: Introduction to PL/SQL

Synopsis
Oracle: Introduction to PL/SQL provides an introduction to the PL/SQL, Oracle's procedural language extension to SQL.

Audience
This course is for programmers and database administrators who will be using PL/SQL with Oracle database products or Oracle Developer/2000.

Time
4 hours

Product Code: PLSC01

After completing Oracle: Introduction to PL/SQL, the user should be able to:

Describe the building blocks of PL/SQL and its environment

Explain the benefits of the basic components of PL/SQL structures

Explain the benefits of packages over stand-alone procedures and functions

Create various types of triggers

Create and use procedures

PL/SQL

PL/SQL Architecture

PL/SQL Basics

PL/SQL Structures

Simple Blocks

Control Structures

Packages

Creating Packages

Debugging Packages

Triggers

Creating a Trigger

Trigger Execution

Stored Procedures

Creating Stored Procedures

Invoking Stored Procedures

This course is distributed with

Exercises, with sample files, that allow users to practice in PL/SQL

A file containing the text of the exercises

Simulations that allow users to practice course skills, even if they don't have access to the PL/SQL product

An Oracle glossary