Oracle 23ai New Feature: Automatic SQL Transpiler
We know that both SQL and PL/SQL have their own execution engines. Every time we call a user defined PL/SQL function from a SQL query, or execute an SQL query in within a PL/SQL code, there is a context switch between the SQL and PL/SQL engines. The cost based optimizer can spend some time to do these context switches. Usually
Read more