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