Interested to Buy Any Domain ? << Click Here >> for more details...
What is a OUTER JOIN?
- 1 Answers
- 2871 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 |
How to create a new table by selecting rows from another table?
How to define an anonymous procedure without variables?
How to assign values to data fields in record variables?
Does oracle database need java?
How to return top 5 rows in oracle?
From the database level, how can you tell under which time zone a database is operating?
What is system global area (sga) in oracle?
How to get a list of all tables in the database?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
is database gud carrier option??
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
Can you create a synonym without having a table?
Oracle General 
