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.
SQL Text Expansion shows us the actual SQL Oracle will run for any given statement…see anything familiar?