got column onupdate working

improvement to Function so that they can more easily be called standalone without having to throw them into a select().

1 files changed, 5 insertions, 0 deletions

diff --git a/lib/sqlalchemy/databases/oracle.py b/lib/sqlalchemy/databases/oracle.py
index 6f5e98265..eab200317 100644
--- a/lib/sqlalchemy/databases/oracle.py
+++ b/lib/sqlalchemy/databases/oracle.py
@@ -209,6 +209,11 @@ class OracleCompiler(ansisql.ANSICompiler):
         self._use_ansi = use_ansi
         ansisql.ANSICompiler.__init__(self, statement, parameters, engine=engine, **kwargs)
         
+    def default_from(self):
+        """called when a SELECT statement has no froms, and no FROM clause is to be appended.  
+        gives Oracle a chance to tack on a "FROM DUAL" to the string output. """
+        return " FROM DUAL"
+
     def visit_join(self, join):
         if self._use_ansi:
             return ansisql.ANSICompiler.visit_join(self, join)