This course provides an introduction to the PL/SQL, Oracle's procedural language extension to SQL.
Objectives:
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
Topics:
PL/SQL
PL/SQL Structures
Packages
Triggers
Stored Procedures
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
