Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 95822 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / prabhat shukla
Basically there are three types of join
1.Inner join
2.Outer join
3.self join
and there are two types of join based on condition.
1.equi-join(if we use equal operator while joining tables)
2.Non-equi-join( if we use other than equal operator while
joining tables.(this on is rarely used.)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to call a sub procedure?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is the string concatenation operator in oracle?
In oracle there is column command, how will you explain that?
what is normalisation?what are its uses?
Does oracle database need java?
Explain user account with reference to oracle.
What is a nvl function? How can it be used?
What is the relation of a user account and a schema?
How to pass parameters to procedures?
What is oracle database 10g express edition?
What is the implicit cursor in oracle?
How can I see all tables in oracle?
Explain the use of control file?
How to rollback the current transaction in oracle?
