Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97118 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / keshavenas
Basically join's are three type's those are :
1.Cross join
2.Equi join
a.Natural join
b.inner join
c.outer join(Simple join)
i.Left outer join
ii.Right outer join
iii.Full outer join
d.Self join
3.Non-equi join
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What's dateware house and what's clustor with practicle example
How to write a query with an inner join in oracle?
Explain oracle insert into command?
What are joins, explain all types of joins?
How to get maxsal , minsal, ename department wise in single query
What are the types of trigger in oracle?
What is dynamic proxy?
What happens in oracle commit?
What are the various oracle database objects?
List out the components of logical database structure of oracle database.
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Can group functions be mixed with non-group selection fields?
How to rename a column in an existing table?
What is background process in Oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
