Interested to Buy Any Domain ? << Click Here >> for more details...
What is a OUTER JOIN?
- 1 Answers
- 2728 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 |
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
How will you differentiate between varchar & varchar2?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is a directory object?
How to retrieve first and last records from a table?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How you find out version of installed workflow?
How to do clean up if create database failed?
What is an oracle cursor variable?
Explain the use of file option in exp command.
What is Index Cluster ?
What operating systems are supported by oracle database 10g xe?
Oracle General 
