What are joins..how many types of joins are there?
Answer Posted / niranjan.b
In sql joins are 3 types
1.Inner join
2.Outer join
a)left outer join
b)right outer join
c)full outer join
3.Cross join
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain the use of indexes option in exp command.
Point the difference between translate and replace?
What is a cognitive schema?
What are the system predefined user roles?
Why is oracle database so popular?
What are the restrictions in a oracle read only transaction?
How does Oracle guarantee data integrity of data changes?
How to change system global area (sga) in oracle?
What are the original export and import utilities?
How to invoke the data pump import utility?
How to turn on or off recycle bin for the instance?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Explain the function of optimizer in oracle?
How does the on-delete-cascade statement work?
How to handle a single quote in oracle sql?