👉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)