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 |
interview questions with answer for cts
How to add a new column to an existing table with a default value?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How to use "startup" command to start default instance?
Can u make a synonym for deptno=10 only from emp table.
what is Table ?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What privilege is needed for a user to insert rows to tables in another schema?
Describe an oracle table?
What are advantages fo Stored Procedures?
What is the difference between Delete, Truncate and Drop in Oracle?