Oracle - what are SQL complimentary 1999 joins? How can we know whether my oracle version supports them?

GeekInterview.com > Tech FAQs > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 6 of 244

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

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 | No

1 0

Overall Rating: +1

March 08, 2006 01:38:09

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 | No

1 0

Overall Rating: +1

July 04, 2008 08:24:25

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

User Name		Remember Me?
Password

Question Bank