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 Elasticsearch in Action this week in the Big Data 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.
I agree. Here's the link:
subject: EXCEPT Set Operation, Oracle, JDBC