Q
Problem solve Get help with specific problems with your technologies, process and projects.

RIGHT OUTER JOIN, LEFT OUTER JOIN and (+)

Oracle 9i introduced joins like RIGHT OUTER JOIN (ROJ), LEFT OUTER JOIN (LOJ) and FULL OUTER JOIN (FOJ). I would say there is an advantage of FOJ. But what is the advantage of ROJ and LOJ over the (+) in previous versions?

In Oracle 9i, Oracle Corp. introduced the RIGHT OUTER JOIN and LEFT OUTER JOIN syntax. Prior to Oracle 9i, one could still perform right and left outer joins by placing the '(+)' characters on the appropriate side of the equals sign in the WHERE clause on the join columns. The new statements do not provide any new functionality that did not exist before. But they do make Oracle 9i more ANSI-SQL compliant. One of the complaints of anti-Oracle vendors was that it didn't support the ANSI-SQL standards. Now, a SQL statement written for SQL Server that does an outer join will work on Oracle without further modification.

For More Information


Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close