PL/SQL Unleashed: New and Advanced Features in Database 23c

Discover the hidden PL/SQL features your peers will wish they knew first.

Main Speaker

Learning Tracks

Course ID

42811

Date

26/11/2025

Time

Daily seminar
9:00-16:30

Location

Daniel Hotel, 60 Ramat Yam st. Herzliya

Overview

PL/SQL is a powerful procedural language that enhances and extends the capabilities of SQL in Oracle databases. It allows developers to build functions and procedures directly inside the database, unlocking performance, security, and flexibility far beyond standard SQL. By mastering the language’s unique features, you can enhance existing applications and develop systems that excel in performance, security, reliability, and maintainability.

This seminar is designed to deepen the expertise of developers and database administrators who work with PL/SQL, enabling them to write high-quality code that runs both within and against the database.

We’ll explore a wide range of advanced topics, highlighting features that improve code quality at multiple levels. Along the way, we’ll uncover lesser-known but highly practical PL/SQL capabilities, while also examining the latest enhancements introduced in Oracle Database releases – from 12c through 23ai.

Who Should Attend

Developers and DBAs with some knowledge and experience in PL/SQL and/or SQL, who want to take their skills to the next level.

Prerequisites

Course Contents

  • SQL and PL/SQL – Relationships of Various Types
  • All about Collections!
  • Cursors: Advanced Topics
  • Bulk Processing
  • Compile Time Warnings
  • Edition-Based Redefinition for Zero Downtime Application Upgrades
  • New Features in Oracle 12c, 18c, 19c, 21c and ✨23ai✨ Just to name a few:
    • SQL Macros
    • Extended Iterators
    • Qualified Expressions
    • JSON Support
    • Whitelists
    • Domains
    • Annotations
    • and many more…
  • Additional Useful Features, Tips and Tricks, and Best Practices
   

The conference starts in

Days
Hours
Minutes
Seconds