Answer Posted / 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 |
Post New Answer View All Answers
How to define an anonymous procedure with variables?
What is the difference between "as" and "is" in an oracle stored procedure?
How to create a table in a specific tablespace?
What is index in Oracle?
How to update a table row with a record?
What happens to the current transaction if the session is killed?
How to loop through a cursor variable?
what is reindexing?
How to unlock the sample user account in oracle?
Explain how you would restore a database using RMAN to Point in Time?
What is the quickest way to export a table to a flat file?
how do u setup a replication site?
How to use an explicit cursor without open statements?
Can a formula column referred to columns in higher group ?
Calculate difference between 2 date / times in oracle sql?
