Interested to Buy Any Domain ? << Click Here >> for more details...
What is a OUTER JOIN?
- 1 Answers
- 2715 Views
- I also Faced
- E-Mail Answers
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?
Oracle General 
