Don't have Telegram yet? Try it now!
https://ardentperf.com/2007/07/18/10g-subquery-unnesting-anomalies/
10g Subquery Unnesting Anomalies