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 |
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
What is the use of oracle?
How to sort output in descending order in oracle?
What is an oracle?
can a view be updated?
How to write numeric literals in oracle?
How to find out what oracle odbc drivers are installed?
What is a nested table?
what is the dual table in oracle?
What is format trigger?
How do I escape a reserved word in oracle?
How many types of auditing in Oracle?