4. Is there a PL/SQL pragma similar to DETERMINISTIC, but for the scope of one single SQL SELECT?

Is there a PL/SQL pragma similar to DETERMINISTIC, but for the scope of one single SQL SELECT?

Answer

If you do this:

select t.x, t.y, (select my_function(t.x) from dual)
from t

then Oracle can use subquery caching to achieve reduced function calls.

All plsql Questions
Ask your interview questions on plsql

Write Your comment or Questions if you want the answers on plsql from plsql Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---