What is a OUTER JOIN?
Answer / parthasarathi
outer join is used to fetch unmatched records along with matched records..
there are 3 kinds of outer joins available.
1.Left outer join :- used to fetch unmatched records at left side table.
2.right outer join :- used to fetch unmatched records at right side table.
3.Full outer join :- used to fetch unmatched records at both side tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
How will you identify oracle database software release?
what is the difference between functional dependecy and multilevel dependency?
Explain an integrity constrains?
How to create a testing table in oracle?
What are the various oracle database objects?
12 RULES OF RDBMS
How to delete an existing row from a table in oracle?
What is recycle bin in Oracle?
Name the three major set of files on disk that compose a database in Oracle?
what is view?
What is index in Oracle?
Can the query output be sorted by multiple columns in oracle?