- The except_() method now renders as MINUS on Oracle,

which is more or less equivalent on that platform.
[ticket:1712]

2 files changed, 11 insertions, 3 deletions

diff --git a/lib/sqlalchemy/dialects/oracle/base.py b/lib/sqlalchemy/dialects/oracle/base.py
index eccf11380..879a296a9 100644
--- a/lib/sqlalchemy/dialects/oracle/base.py
+++ b/lib/sqlalchemy/dialects/oracle/base.py
@@ -306,7 +306,14 @@ class OracleCompiler(compiler.SQLCompiler):
     statements to work under non-ANSI configured Oracle databases, if
     the use_ansi flag is False.
     """
-
+    
+    compound_keywords = util.update_copy(
+        compiler.SQLCompiler.compound_keywords,
+        {   
+        expression.CompoundSelect.EXCEPT : 'MINUS'
+        }
+    )
+    
     def __init__(self, *args, **kwargs):
         super(OracleCompiler, self).__init__(*args, **kwargs)
         self.__wheres = {}
diff --git a/lib/sqlalchemy/dialects/sqlite/base.py b/lib/sqlalchemy/dialects/sqlite/base.py
index dfc09f025..37e63fbc1 100644
--- a/lib/sqlalchemy/dialects/sqlite/base.py
+++ b/lib/sqlalchemy/dialects/sqlite/base.py
@@ -191,8 +191,9 @@ ischema_names = {
 
 
 class SQLiteCompiler(compiler.SQLCompiler):
-    extract_map = compiler.SQLCompiler.extract_map.copy()
-    extract_map.update({
+    extract_map = util.update_copy(
+        compiler.SQLCompiler.extract_map,
+        {
         'month': '%m',
         'day': '%d',
         'year': '%Y',