Thursday, August 20, 2009

SkillBuilders: Oracle10g PL/SQL Programming Workshop Outline

SkillBuilders: Oracle10g PL/SQL Programming Workshop Outline: "Topic Summary

* Introduction to PL/SQL
o What is PL/SQL?
o Why Use PL /SQL?
o PL/SQL Program Structure
o Anonymous Blocks
o Compile Errors
o Sending Output to SQL*Plus
o Introduction to Procedures
o Procedure Compile Errors
o Procedure Compile Warnings (10g)
o Introduction to Functions
o Introduction to Packages
o Querying the Data Dictionary
o Introduction to Triggers
o Tools for PL/SQL Development
o Working in SQL*Plus"