Oracle PL/SQL - Programming for Advanced Users (ORA5A)

Databases, Oracle

This course is for developers who already know SQL and PL/SQL and want to master advanced PL/SQL techniques for designing and implementing highly efficient Oracle program units. The course covers practical use of cursors, packages and collections.

Participants gain hands-on skills to optimize performance, build flexible applications and improve database efficiency by using LOBs, result caching and profiling. Emphasis is on design patterns, memory use and maintainability for Oracle PL/SQL.

Location, current course term

Brno + online (volitelně)	12/15/2025 - 12/16/2025 CZECH Order 3/9/2026 - 3/10/2026 CZECH Order
Praha + online (volitelně)	9/22/2025 - 9/23/2025 CZECH Order 10/23/2025 - 10/24/2025 CZECH Order
Custom	Customized Training (date, location, content, duration)

The course:

Hide detail

• Overview of collections

• Using associative arrays (index-by tables)

• Using nested tables

• Using VARRAYs

• Efficient use of collections

• Defining collection and object types

• PL/SQL object type instances

• PL/SQL constructors

• PL/SQL attributes

• PL/SQL member methods

• PL/SQL inheritance for object types

• Manipulating objects in PL/SQL

• Sharing objects between sessions

• Order and Map methods for object collections

• Improve memory use with SQL result set caching

• Enabling PL/SQL function result caching

• Profiling PL/SQL applications

• Creating and maintaining LOB data types

• Using the DBMS_LOB PL/SQL package to manage LOBs

• Characteristics and advantages of SecureFile LOBs

• Guidelines for cursor design

• Enabling deduplication, compression and encryption for SecureFile LOBs

Assumed knowledge:

Basic knowledge of PL/SQL.

Recommended previous course:

Oracle Database - Programming in PL/SQL (ORA5)

Schedule:

2 days (9:00 AM - 5:00 PM )

Course price:

552.00 € ( 667.92 € incl. 21% VAT)

Language: