PL/SQL functions defined in SQL queries🤯
Loïc
Posted on April 7, 2022
👉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
💖 💪 🙅 🚩
Loïc
Posted on April 7, 2022
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.