What are joins..how many types of joins are there?
Answer Posted / reshma patil
when you want to retrive data from two or more tables then
you require joins.
Types of joins:-
1)Cross join/Cartain join
2)Equi join/inner join
3)Outer join
4)Self join
5)Non-equi join
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the sid in oracle?
How to start instance with a minimal initialization parameter file?
What is the simplest tool to run commands on oracle servers?
How to connect asp pages to oracle servers?
What is Undo Management Advisor in Oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
Explain enable novalidate constraint.
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Explain what are the uses of rollback segment?
How can you use check constraints for self referential integrity?
Is there a combination of "like" and "in" in sql?
Which environment variables are absolutely critical in order to run the OUI?
What is the data pump export utility?
What is data type in oracle?