File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes EXCEPT Set Operation, Oracle, JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "EXCEPT Set Operation, Oracle, JDBC" Watch "EXCEPT Set Operation, Oracle, JDBC" New topic

EXCEPT Set Operation, Oracle, JDBC

Dave Soto
Ranch Hand

Joined: Sep 15, 2001
Posts: 55
The SQL standard defines set operations UNION, EXCEPT, and INTERSECT. For some odd reason, Oracle departs from this syntax by replacing EXCEPT with MINUS. MINUS behaves exactly as you would expect EXCEPT to behave. Here is my problem:
I was hoping that I could use EXCEPT in my JDBC statements, and that somehow the JDBC driver would know to replace my EXCEPT with a MINUS before querying the database. Instead, the only way it works is if I use MINUS in my JDBC statements.
This is very undesireable, as we occasionally may use a different database. Up to this point all other statements have translated nicely.
Is there a JDBC escape sequence, or some other way to accomplish a database-independent way of performing the EXCEPT set operation? Thanks.
jQuery in Action, 3rd edition
subject: EXCEPT Set Operation, Oracle, JDBC
It's not a secret anymore!