Ask the Expert

Is a full outer join possible in Oracle?

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: