Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97077 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / neet verma
A JOIN is a means for combining fields from two tables by
using values common to each.
there are three types of joins:-
1)inner join
a)eqi join
b)natural join
c)cross join
2)outer join
a)Left outer join
b)Right outer joins
c)Full outer join
3) self join
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Why cursor variables are easier to use than cursors?
Can we commit inside a function in oracle?
What are the components of logical database structure in oracle database?
What are data pump export and import modes?
What is the difference between truncate & delete command?
How to check database size in Oracle?
What is the usage of analyze command in oracle?
What privilege is needed for a user to insert rows to tables in another schema?
how to join query for one source type is oracle another source type is sql server ?
What is a cursor variable?
What happens if the imported table already exists?
What is the difference between substr & instr functions?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
what are the default admin accounts in Oracle 10g ?
What is raw datatype?
