Course Objectives
After completing this course,you should be able to do the following:
- Create,execute,and maintain
- -Package constructs
- -Database triggers
- Manage PL/SQL subprograms and triggers
- Use a subset of Oracle-supplied packages to generate screen and file output
- Identify various techniques that impact your PL/SQL code design considerations
- Use the PL/SQL compiler,manage PL/SQL code,and manage depdendencies
Corse Agenda
- Introduction
- Creating Packages
- Working with Packages
- Using Oracle-Supplied Packages in Application Development
- Using Dynamic SQL
- Design Considerations for PL/SQL cODE
- Creating Triggers
- Creating Compound,DDL,and Event Database Triggers
- Using the PL/SQL Compiler
- Managing PL/SQL Code
The Human Resources(HR) Schema That is Used in This Course
Oracle 11g SQL and PL/SQL Documentation
- Oracle Database New Features Guide 11g Release 2(11.2)
- Oracle Database Advanced Application Developer`s Guide 11g Release 2(11.2)
- Oracle Database PL/SQL Language Reference 11g Release 2(11.2)
- Oracle Database Reference 11g Release 2(11.2)
- Oracle Database SQL Language Reference 11g Release 2(11.2)
- Oracle Database Concepts 11g Release 2(11.2)
- Oracle Database PL/SQL Packages and Types Reference 11g Release 2(11.2)
- Oracle Database SQL Developer User`s Guide Release 1.5
Additional Resources
- For additional information about the new Oracle 11g SQL and PL/SQL new features,refer to the following:
- Oracle Database 11g:New Features eStudies
- Oracle By Example(OBE) series:Oracle Database 11g: http://www.oracle.com/technetwork/tutorials/index.html
- What`s New in PL/SQL in Oracle Database 11g on the Oracle Technology Network(OTN) http://www.oracle.com/technology/tech/pl_sql