Build Database APIs with PL/SQL in Oracle Database 23ai

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

[ItsMrVD]

Why are we complicating simple things(Loop)?