Data Deliverance Courseware

Introduction to Oracle10g PL/SQL Programming


The Oracle® 10g release has greatly enhanced the features and functionality of PL/SQL. Students will learn the fundamentals of the PL/SQL programming language. Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will learn programming, management, and security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features.

A solid understanding of SQL and 3GL programming is required. It is recommended the student understand Oracle 10g SQL features.

Course Objectives
On completion of this course, the student should be able to

Intended Audience
Application developers and database administrators

3 Days

Instructor-led course, with practical computer-based exercises.

Course Outline

Hardware and Software Requirements

Course exercises require Oracle 10g running on a Microsoft Windows, Linux, or multi-user UNIX system. See the appropriate course Setup Guide for details.

A good minimal hardware profile for this course would have a Pentium 500-MHz or equivalent CPU, 512 MB of RAM, and at least 4 GB of free disk space for the Oracle installation.