What are joins..how many types of joins are there?
- 29 Answers
- 76743 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / neet verma
A JOIN is a means for combining fields from two tables by
using values common to each.
there are three types of joins:-
1)inner join
a)eqi join
b)natural join
c)cross join
2)outer join
a)Left outer join
b)Right outer joins
c)Full outer join
3) self join
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Give the advantages and disadvantages of clusters.
What are the various types of snapshots ?
What is ADDM Advisor in Oracle?
how to join query for one source type is oracle another source type is sql server ?
Explain integrity constraints?
How to use "if" statements on multiple conditions?
Explain what are clusters?
How to select some rows from a table in oracle?
How can you use check constraints for self referential integrity?
Name the three major set of files on disk that compose a database in Oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to list all tables in your schema?
Why do you use stored procedures and state some of its disadvantages?
What is sequence?
What is the difference between a hot backup and a cold backup in oracle?
