My Oracle Support Banner

23ai New Feature - Automatic PL/SQL to SQL Transpiler (Doc ID 3002410.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 23.4 and later
Oracle Database - Standard Edition - Version 23.4 and later
Information in this document applies to any platform.

Goal

Above 23ai, SQL containing PL/SQL functions implemented the ability to automatically convert PL/SQL functions to SQL expressions whenever possible.
This implementation can expect to reduce PL/SQL calls and reduce execution time.

This document has a use case example of the new 23ai feature "Automatic PL/SQL to SQL Transpiler".


For more details, see document:

Oracle Database Release 23
Oracle Database New Features
2 Application Development
Automatic PL/SQL to SQL Transpiler
https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/application-development.html#GUID-C4C623EE-0E37-47CE-8591-F136C7F47DB3

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.