This week's book giveaway is in the Cloud/Virtualizaton forum.
We're giving away four copies of Mesos in Action and have Roger Ignazio on-line!
See this thread for details.
Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

A query in naming conventions of Oracle Joins

 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
DOnt know why all the terms are invented by Oracle , Apart from Ansi formats introduced from Oracle 9I

IS there any difference between Right Join and Right Outer Join ?

I assume that the Equi Join and Inner Joins means the sam e, correct me if i am wrong ??

Waiting fo your replies . Thanks in advnace .


 
Christophe Verré
Sheriff
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In Oracle, outer joins are called either left outer join and right outer join, depending on which table the joined table is.
Using "left" or "right" implies that this is an outer join, so you can drop the OUTER keyword in your queries. Thus, there's no different between RIGHT JOIN and RIGHT OUTER JOIN.

I assume that the Equi Join and Inner Joins means the sam e, correct me if i am wrong ??

If by Equi Join you mean using "=" on both columns, then that's correct.
 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you very much Christophe .
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic