PL/SQL functions defined in SQL queries🤯

#database #sql #performance #programming

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

New AI Method Makes Language Models Smarter Through Adversarial Context Training

Mike Young - Feb 17

AI System Generates Molecular Structures from Mass Spectra with 92% Accuracy

Mike Young - Feb 15

AI Models Still Struggle to Remember Your Personal Preferences, Study Shows

Mike Young - Feb 15

AI Agents Create Their Own Tools to Master 3D Spatial Reasoning

Mike Young - Feb 14

DEV Community

PL/SQL functions defined in SQL queries🤯

Top comments (0)

Postgres on Neon - Get the Free Plan

Read next

New AI Method Makes Language Models Smarter Through Adversarial Context Training

AI System Generates Molecular Structures from Mass Spectra with 92% Accuracy

AI Models Still Struggle to Remember Your Personal Preferences, Study Shows

AI Agents Create Their Own Tools to Master 3D Spatial Reasoning

Okay