What are joins..how many types of joins are there?
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
What is transaction control statement and how many types of transaction control statement in Oracle?
What is Virtual Private Database in Oracle?
What is a trigger and what are its types?
What is null value in oracle?
What are the different types of trigger and explain its various uses and functions?
What privilege is needed for a user to create indexes in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How do I spool to a csv formatted file using sqlplus?
What is format trigger?
Why does Oracle not permit the use of PCTUSED with indexes?
What is a read write transaction in oracle?
Use of an integrity constraint is better to validate data. Explain
What privilege is needed for a user to insert rows to tables in another schema?
How to use values from other tables in update statements using oracle?
What is ceil and floor in oracle?