Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

Advanced PL/SQL

Recommended Duration:
2 Days
Version: Oracle 12c R2
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 andREF Cursors
  • Oracle Objects: Types & Subtypes
  • Associative Arrays (aka 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
  • Deprecating Code
  • Constant data-type lengts
  • Code coverage package
  • JSON in the database