Q

Is a full outer join possible in Oracle?

Is a full outer join possible in Oracle? I thought I had to join two outer join queries with a UNION statement.

You spoke about a full outer join. Is this possible in Oracle? I only know the left and right outer joins (+). The only way I know to do a full outer join is to join two outer join queries with a UNION statement.

Before Oracle 10g, the only way to perform a full outer join was to use two queries -- one that does a right outer join and the other that does a left outer join. And then use the UNION or UNION ALL operator between the two result sets to combine them into a full outer join.

Oracle 10g introduced the the ANSI-compliant FULL OUTER JOIN clause which makes the above unnecessary.

This was first published in June 2007

Dig deeper on Oracle and SQL

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close