Click here to Skip to main content
15,074,483 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?
Posted
Comments
PIEBALDconsult 1-Apr-15 14:48pm
   
Yes.
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.
   
Comments
Maciej Los 1-Apr-15 15:04pm
   
+5!
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