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 to retrieve values from data fields in record variables?
How to drop a stored procedure in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to best split csv strings in oracle 9i?
How to create a new oracle data file?
Explain index?
What is system global area (sga) in oracle?
Explain the characteristics of oracle dba?
what happened to the global index when I truncate the data in one of the partition?
Why is oracle database so popular?
How to import one table back from a dump file?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
Explain oracle left join with an example?
Whether any commands are used for months calculation? If so, what are they?
What is the difference between post-database commit and post-form commit?