What are joins..how many types of joins are there?
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
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is integrity and what is constraint??Explain with example
How to export your own schema?
What is the difference between I and G in Oracle?
What is oracle analytical function?
State all possible different index configurations a table can possibly have?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How can Oracle users be audited?
What are a collation and state the different types of collation sensitivity?
How to define a variable of a specific record type?
What is an oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How to put more than 1000 values into an oracle in clause?
How to start an oracle instance?
What is the difference between a user and a schema in oracle?