GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Oracle
Go To First  |  Previous Question  |  Next Question 
 Oracle  |  Question 6 of 244    Print  
what are SQL complimentary 1999 joins? How can we know whether my oracle version supports them?

  
Total Answers and Comments: 3 Last Update: July 04, 2008     Asked by: opk_pavan 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: JANA_NAR_JP
 

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



Above answer was rated as good by the following members:
lanka_satya
February 27, 2006 07:43:29   #1  
JANA_NAR_JP        

RE: what are SQL complimentary 1999 joins? How can we ...

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


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
March 08, 2006 01:38:09   #2  
pawan ahuja Member Since: March 2006   Contribution: 6    

RE: what are SQL complimentary 1999 joins? How can we ...

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)


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
July 04, 2008 08:24:25   #3  
lanka_satya Member Since: January 2008   Contribution: 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



 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape