JANA_NAR_JP

• Feb 27th, 2006

 

The complimentary joins are

1.Cross JOIN

2.Natural JOINS

3.Using Clause

4.Full or two sided outer joins

5.Arbitrary join conditions for outer JOINs

pawan ahuja

 Profile Answers by pawan ahuja 

• Mar 8th, 2006

 

Hi all,

Actually we r talking abt the ANSI join syntax,That's available in oracle 9i.this join cannot

be run in lower version means oracle 8i(8.17),oracle 9i releases1.

The join syntax is left outer join,rigth outer join,full outer join.natural join,

Regards

Pawan Ahuja

91(9342927335)

 

 

lanka_satya

 Profile Answers by lanka_satya 

• Jul 4th, 2008

 

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