What are joins..how many types of joins are there?
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
How can you use check constraints for self referential integrity?
What is instant client oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Is oracle an open source?
What is system global area (sga) in oracle?
What is ASM (Automatic Storage Management) in Oracle?
How to define a record variable to store a table row?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Differentiate between function and procedure in oracle.
What are the components of logical database structure in oracle database?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What is the data type of dual table?
What is data file?
what is a Nested Loop join?
Explain oracle insert into command?