PL/SQL - What is the difference between right join and right outer join..

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 192 of 241

What is the difference between right join and right outer join..

Total Answers and Comments: 3

Last Update: May 13, 2008 Asked by: MuthuKrishnan

Sponsored Links

Best Rated Answer

—

Submitted by: krishnaindia2007

Both are same. Right outer join returns all the reocrds that satisfy the join condtion + rest of the records from right (or second) table.

Above answer was rated as good by the following members:
kperumal75, sojimonsn

September 26, 2007 11:52:17

ramaswamy80in

Member Since: September 2007 Contribution: 2

RE: What is the difference between right join and righ...

when we join two tables if one of them is deficient of rows then we use outer jion
if the right side table is deficient of rows we use right outer join and vise versa

Is this answer useful? Yes | No

1 0