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
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How many types of segments in Oracle?
Difference between open_form and call_form in oracle.
Explain the use of indexes option in exp command.
Is there an oracle sql query that aggregates multiple rows into one row?
How do I uninstall oracle 11g?
How to convert characters to numbers in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
Explain the use of owner option in exp command.
Explain cascading triggers.
Respected sir, Please send me technical questions related to oracle apps..
How to call a stored function in oracle?
What is an Oracle Instance?
Explain the use of log option in exp command.
Is oracle the best database?