Oracle 11g PL/SQL Program Units
|Length: 2 days
|Audience: Programmers and Database Administrators responsible for the development or maintenance of application systems which access an Oracle database.
|Prerequisites: Oracle 11g PL/SQL Programming
The course provides attendees with the background to develop stored PL/SQL
programs including functions, procedures, packages, and triggers. Commonly used
predefined packages provided with the Oracle11g DBMS are examined. Discussions
include how these packages could be used as part of in-house applications.
Additional PL/SQL features such as native dynamic SQL support and autonomous
transactions are also presented.
Workshops provide students with the opportunity to use predefined packages and
evaluate their potential role in an application as well as to write their own
stored PL/SQL objects.
- Review of PL/SQL Syntax
- PL/SQL on the Server
- Creating and Calling Stored Procedures
- Creating and Calling Stored Functions
- Passing Parameters
- Definer's versus Invoker's Rights
- Creating and Using Packages
- Cross-Session PL/SQL Function Result Cache
- Database Triggers
- Compound Triggers
- Advanced Features
- PL/SQL Associative Arrays
- BULK COLLECT
- Native Dynamic SQL
- Autonomous Transactions
- PL/SQL Hierarchical Profiler
- Native Compilation
- Subprogram Inlining
- Predefined Packages