Simple Data Processing with PL/SQL in Oracle Database 23c - CloudWorld 2022

Discover the latest enhancements in PL/SQL for Oracle Database 23c in this CloudWorld 2022 conference talk. Explore how to build efficient database APIs and manage data with improved features such as better loops, extended case expressions, and JavaScript Object Notation integration. Learn about currency conversion APIs, looping through arrays, using indices, qualified expressions, SQL macros, and textual find-replace functionalities. Gain insights from Chris Saxon, senior developer advocate at Oracle, on leveraging these new PL/SQL capabilities to simplify data processing and develop robust data-driven applications.

Introduction
Currency Conversion API
Looping through arrays
Using indices
Qualified Expressions
Loops
SQL Macros
Textual Find Replace
Review