What is the difference between Outer join and Full outer join?
Answer Posted / sakshisree
Outer Join:
There are three types of outer joins namely:
Left Outer Join---For retreiving all the columns from the
first table irrespective of the column match.
Right Outer Join---For retreiving all the columns from the
second table irrespective of the column match
Full Outer Join---For retreiving all the columns from both
the tables irrespective of column match.
| Is This Answer Correct ? | 38 Yes | 12 No |
Post New Answer View All Answers
Explain view?
What are a collation and state the different types of collation sensitivity?
How does Oracle guarantee data integrity of data changes?
How to set up autotrace for a user account?
What are the types of partitions in oracle?
How to do paging with oracle?
What do you mean by a tablespace?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Explain joins in oracle?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How to delete all rows a table in oracle?
How to invoke the data pump import utility?
How to start an oracle instance?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Explain a synonym?