Interested to Buy Any Domain ? << Click Here >> for more details...
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 set a transaction to be read only in oracle?
Explain constraining triggers.
what is reindexing?
How to install oracle odbc drivers?
How would you begin to troubleshoot an ORA-3113 error?
How to convert a date to char in oracle? Give one example.
What is the best way to do multi-row insert in oracle?
Can the query output be sorted by multiple columns in oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is a lookup table in oracle?
Explain the use of ignore option in imp command.
What is the order of defining local variables and sub procedures/functions?
definition of cluster and non-clustered index?
What is a view and how is it different from a table?
does the query needs a hint to access a materialized view?
