Welcome to PL/SQL programming in Oracle8i! This course introduces you to the object-oriented paradigm within the context of Oracle8i, then focuses on the SQL and PL/SQL commands for creating, modifying, and manipulating data within objects such as object tables and related object tables. This course also covers nested tables, varrays, LOBs, object types, and objects embedded within relational tables. You'll learn the steps necessary to create and use methods written in PL/SQL to manipulate data within objects.
This is the first course in the five-part Oracle8i New Features Certification Series.
Taken in conjunction with the other courses within this website, this course will prepare you to pass the Oracle8i New Features for Administrators certification exam.
Along the way, you will work on a series of course projects and exercises that will give you a chance to put your new skills to use in the context of actual business scenarios.