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
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is the purpose of save points in oracle database?
how to join query for one source type is oracle another source type is sql server ?
What is ADDM Advisor in Oracle?
What are the types of trigger in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Explain an extent?
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 system tablespace?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How can you merge two tables in oracle?
What are the uses of Database Trigger ?
Explain enable novalidate constraint.
What is procedure overloading in oracle?
How to change program global area (pga) in oracle?
