| |
GeekInterview.com > Tech FAQs > Oracle
| Print | |
Question: what are SQL complimentary 1999 joins? How can we know whether my oracle version supports them?
|
| July 07, 2008 08:24:25 |
#3 |
| lanka_satya |
Member Since: January 2008 Total Comments: 16 |
RE: what are SQL complimentary 1999 joins? How can we know whether my oracle version supports them?
|
oracle supports two types of joins:
1.oracle joins
cartesian join
equi join
non equi join
self join
outer join is exhibited using "+" operator
2.ansii joins(SQL 1999 complimentary joins)
these joins has support from oracle 9i database
we have
cross join
natural join
join using "using"
join using "on"
left outer join
right outer join
full outer join
these ansii joins will work on all the standard rdbms softwares
|
| |
Back To Question | |
