Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Right Outer Join in Oracle

 
Skanda Raman
Ranch Hand
Posts: 205
Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic