SQL Text Expansion shows us the actual SQL Oracle will run for any given statement…see anything familiar?
Monday, 09 September 2019 19:16
ANSI or Oracle Style Joins?Written by https://www.thatjeffsmith.com/archive/2019/09/ansi-or-oracle-style-joins/
I like Oracle, you like ANSI – but that’s OK! We can both win!
A wee secret…even ANSI joins often run as Oracle
If you look at the code,
UNDER the code, the Optimizer has re-written our statement.
Published in ORACLE
Leave a comment
Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.