Oracle 23ai New Feature: Automatic SQL Transpiler
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/transpiler.png?w=385&h=33&crop=1)
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