My Oracle Support Banner

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

Last updated on FEBRUARY 06, 2024

Applies to:

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


Above 23c, 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 23c 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



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

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