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.