Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

Advanced PL/SQL

Recommended Duration:
2 Days
Version: Oracle 12c and 11g
Course can be taught with earlier versions of the database.
Benefits
PL/SQL developers will learn to use advanced features enabling improved programming and enhanced performance.
Audience
Experienced PL/SQL developers who need to advance their PL/SQL skills.
Prerequisites
Working Oracle PL/SQL experience of at least six months or completion of “Oracle PL/SQL for Developers” (or equivalent) course.
Exercises
There are twelve hands-on exercises.
Major Topics
  • Review of PL/SQL
  • Exception Handling overview
  • Procedures, Functions, Packages
  • Invoker Rights
  • Autonomous Transactions
  • Using Overloading
  • Dependencies
  • Triggers
  • SQL RETURNING Clause
  • Oracle-Supplied Packages
  • Fine-grained security: DBMS_RLS, DBMS_SESSION, others
  • Implicit and Explicit Cursors
  • Cursor variables, REF Cursors, parms
  • Oracle Objects: Types & Subtypes
  • Associative Arrays (PL/SQL tables)
  • Nested Tables & VARRAYS
  • Using External C & OS routines
  • Create Java Class "Wrapper"
  • Using Java classes from PL/SQL
  • Performance and PL/SQL
  • BULK COLLECT and FORALL
  • NOCOPY hint
  • PL/SQL Memory and SGA
  • Caching and RESULT_CACHE
  • PL/SQL in SQL WITH
  • PRAGMA UDF
  • Native Dynamic SQL
  • Tracing & Profiling PL/SQL
  • UTL_CALL_STACK
  • Wrapping PL/SQL Code