It's not a secret anymore!
The moose likes Oracle/OAS and the fly likes Right Outer Join in Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Right Outer Join in Oracle" Watch "Right Outer Join in Oracle" New topic

Right Outer Join in Oracle

Skanda Raman
Ranch Hand

Joined: Mar 21, 2008
Posts: 205

I want to use right outer join in oracle 8i. I have my query as below.

I am getting the below error.

Even while i use LEFT OUTER JOIN also, i get the same error. My query while using left outer join

The error i got for this is as below

Please let me know how to use these joins. I am using Oracle 8i

pranjal mishra

Joined: Jan 08, 2009
Posts: 21
The problem is simple buddy, the query syntax you are using supports Oracle 9i and higher. Its called ANSI/ISO Syntax. Instead of using this, try the older one, which most of the developers use to avoid the error.
It goes like this.

This is the example of left outer join. The (+) operator is on the left side of the compare operator, if you put it on the right side you'll get the right outer join.

I hope this helps you out.

SCJP 1.5(95%)
I agree. Here's the link:
subject: Right Outer Join in Oracle
It's not a secret anymore!