Does Oracle provides caching for Corelated Sub-queries?
So let's say I have a query like -
SELECT ..
, NVL (( SELECT a FROM b WHERE a.a = m.a)
, ( SELECT c FROM d WHERE c.a = m.a)
)
, (SELECT e FROM f WHERE e.a = m.a)
FROM m
WHERE ...;
Say there are 100 Million rows and 100 possible values for (m.a). Will Oracle cache these queries for the same run? Will this caching be available across sessions?
Or Oracle does not cache co-related subqueries?