Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Outer join and Full outer join?
- 5 Answers
- 39967 Views
- I also Faced
- E-Mail Answers
Answer Posted / pushpa g
in NON-ANSI syntax ,we have two types of outer joins,
those r 1. left outer join.
2. right outer join.
in ANSI syntax ,we have three types of joins.
1. left outer join.
2.right outer join.
3.full outer join.
in L.O.J. and R.O.J. we get only matched columns from both
the tables.
but in F.O.J. we can get matched+ unmatched data from
both the tables.
| Is This Answer Correct ? | 11 Yes | 11 No |
Post New Answer View All Answers
what are the default admin accounts in Oracle 10g ?
Explain a data segment?
How to return top 5 rows in oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to invoke the data pump import utility?
How do I connect to oracle?
How to unlock the sample user account in oracle?
Explain an exception and its types?
How to compare dates in oracle sql?
What is meant by raw datatype?
How to connect to oracle using service name instead of sid?
Can we call procedure inside function in oracle?
Explain how are indexes update?
What is Library Cache in Oracle?
Is oracle an open source?
