Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 96985 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
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
How to add a new column to an existing table in oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
Explain an integrity constrains?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How to find out what oracle odbc drivers are installed?
Is oracle an open source?
What is the data pump export utility?
What are named parameters?
What is a parameter file in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How do I find the database name in oracle?
What are the advantages of oracle?
How do we create privileges in oracle?
How to loop through a cursor variable?
How to delete a column in an existing table?
