DEV Community

Loïc
Loïc

Posted on

PL/SQL functions defined in SQL queries🤯

PL/SQL function defined in SQL query

👉PL/SQL functions in the SQL WITH clause: Your PL/SQL function defined in the WITH clause of a subquery! Results in better performance as compared with schema-level functions.🥳

📖Documentation: https://docs.oracle.com/database/121/NEWFT/chapter12101.htm#NEWFT146

💻Gist to reproduce: https://gist.github.com/loiclefevre/ddab41639f92f36cf7b09570d3174812

Top comments (0)