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
Explain the difference between sap and oracle?
What are the most common interview questions on ETL Testing for experience?
Explain the use of owner option in exp command.
List the various oracle database objects?
Explain oracle 12c new features for developers?
Please explain drop constraint oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Can we store images in oracle database?
What is the dynamic sql in oracle?
How to find out what oracle odbc drivers are installed?
What are the various oracle database objects?
What is a table index?
How to use subqueries in the from clause in oracle?
Explain a private synonyms?
can anyody please send me the dump for Oracle 10g certifications for DBA path?