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
How to sort output in descending order in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
Can we write insert statement in function in oracle?
Explain mutating triggers.
What is Library Cache in Oracle?
How to filter out duplications in the returning rows using oracle?
What is pragma autonomous transaction in oracle?
How to add another datafile to a tablespace?
what are bitmap indexes? How does they work?
What are the ways tablespaces can be managed and how do they differ?
How to execute the package in oracle?
What do you understand by a database object? Can you list a few of them?
What is a lookup table in oracle?
What is a read write transaction in oracle?