What are joins..how many types of joins are there?
Answer Posted / rama mohan reddy
ACTUALLY PRIOR 8i THERE ARE 4 TYPES OF JOINS ARE THERE THEY ARE
1. EQUI JOIN
2. NON EQUIJOIN
3. SELF JOIN
4. OUTER JOIN
A) LEFT OUTER JOIN
B) RIHT OUTER JOIN
BUT ANSI PROIDES NEW JOINS FROM 1999 THEY ARE
1. CROSS JOIN
2. NATURAL JOIN
3. USING CLAUSE
4. INNER JOIN //SAME AS EQUI JOIN PRIOR 1999
5. SELF JOIN //SAME AS SELF JOIN PRIOR 1999
6. RIHT OUTER JOIN
7. LEFT OUTER JOIN
8.FULL OUTER JOIN
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Are truncate and delete commands same? If so why?
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 ?
What operating systems are supported by oracle database 10g xe?
How to use "out" parameter properly?
When do we use group by clause in a sql query?
What is backup in Oracle?
How to invoke the original export import utilities?
How to use in conditions in oracle?
What is an oracle table?
Explain oracle insert into command?
How to use "startup" command to start default instance?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What are the uses of Database Trigger ?
How to define a specific record type?
How to connect to oracle using service name instead of sid?