Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Outer join and Full outer join?
- 5 Answers
- 40221 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 privileges and grants?
Does oracle partitioning improve performance?
Why should I use oracle database?
What do you know about normalization? Explain in detail?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Explain how you would restore a database using RMAN to Point in Time?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
what is Single Byte Overhead...?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to write an inner join with the where clause in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
if you ctreate table identity
What is a schema in oracle?
How do you find current date and time in oracle?
Explain how are indexes update?
