Click here to Skip to main content
15,908,673 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Can anyone please help me to know the difference between ansi left join and left join with ((+)) syntax?Do they produce the same results when one is converted to other?And which one is the older one?
PIEBALDconsult 1-Apr-15 14:48pm    
Maciej Los 1-Apr-15 15:05pm    
I like it!
Mohibur Rashid 2-Apr-15 4:10am    
me like too

1 solution

Difference between Oracle's plus (+) notation and ansi JOIN notation?[^]

The + syntax is older, and is only included for backwards-compatibility. It also has some restrictions which the ANSI JOIN syntax doesn't have.

Oracle recommend[^] that you only use the ANSI syntax.
Share this answer
Maciej Los 1-Apr-15 15:04pm    
Jörgen Andersson 1-Apr-15 16:51pm    
Funnily enough, Oracle doesn't follow their own recommendations. :rolleyes:
Should also mention that the optimizer doesn't always produce the same plan for Ansi and Implicit joins. Have been hit quite badly by that in the past.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900