Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ANSI JOIN vs old Oracle join - what's the difference

BEDEApr 4 2008 — edited Apr 7 2008
Since Oracle 7, I've been using classical Oracle joins in the where clause, and for outer join the old Oracle (+).
Now, does the ANSI-style with "left/right [outer] join on" do anything different? Meaning: does the DB server perform somewhat different? I find this ANSI syntax rather baroque, but, if it does have some REAL ADVANTAGES, I'll use it.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2008
Added on Apr 4 2008
18 comments
14,742 views