File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

Right Outer Join in Oracle

Eshwar Prasad
Ranch Hand

Joined: Mar 21, 2008
Posts: 202
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

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: http://aspose.com/file-tools
 
subject: Right Outer Join in Oracle
 
Similar Threads
iBatis and Parameter Map
Oracle update query question
how to fetch data from resultset containing result of two queries
delete sql
insert into join tables