With tight SQL integration, PL/SQL has long been the perfect language for building database APIs to manage your data.

Oracle Database 23ai continues to enhance PL/SQL with better loops, extended case expressions, and better JSON integration. And best of all: the automatic SQL transpiler, which removes the context switch between the SQL and PL/SQL languages! This gives you the code reuse benefits of PL/SQL with the performance of pure SQL.

These changes simplify your PL/SQL code, making it easier to read, write, and test. Watch this session to learn what’s new in PL/SQL to help you build data-driven applications.

Highlights of the session include:

• 02:40 - Exrate conversion function
• 03:10 - Pre-23ai API implementation
• 07:15 - PL/SQL loop enhancements in 21c demo
• 17:40 - Looping through arrays
• 22:40 - Qualified expressions/type constructors
• 28:15 - Scalar SQL macros
• 34:25 - Automatic SQL transpiler
• 37:30 - Demo of macros and transpiler
• 47:10 - Extended CASE controls
• 49:40 - JSON <> PL/SQL conversions
• 54:15 - Demo of updated API using 23ai functionality
• 56:50 - Recap