# HG changeset patch
# User catherine@cordelia
# Date 1211292494 14400
# Node ID 2de82dd6eba2d6bc0d05d4f22a1b18ed5e6aa382
# Parent  ca5d615d8207121621bdf7f06d0df78f3a4c5750
back to dellzilla

diff -r ca5d615d8207 -r 2de82dd6eba2 sqlpyPlus.py
--- a/sqlpyPlus.py	Mon May 19 17:15:31 2008 -0400
+++ b/sqlpyPlus.py	Tue May 20 10:08:14 2008 -0400
@@ -573,12 +573,11 @@
             return
         object_type, owner, object_name = self.resolve(arg.strip(self.terminator).upper())
         if not object_type:
-            if opts.all:
-                self.do_select("""object_name, object_type%s FROM %s_objects
-                               WHERE object_type IN ('TABLE','VIEW','INDEX')
-                               AND   object_name LIKE '%%%s%%'
-                               ORDER BY object_name""" %
-                               (which_view[0], which_view[1], arg.upper()) )
+            self.do_select("""object_name, object_type%s FROM %s_objects
+                           WHERE object_type IN ('TABLE','VIEW','INDEX')
+                           AND   object_name LIKE '%%%s%%'
+                           ORDER BY object_name""" %
+                           (which_view[0], which_view[1], arg.upper()) )
             return                    
         self.stdout.write("%s %s.%s\n" % (object_type, owner, object_name))
         descQ = descQueries.get(object_type)
@@ -858,8 +857,8 @@
     def do_declare(self, arg):
         self.anon_plsql('declare ' + arg)
 
-    def do_create(self, arg):
-        self.anon_plsql('create ' + arg)
+    #def do_create(self, arg):
+    #    self.anon_plsql('create ' + arg)
 
     @options([make_option('-l', '--long', action='store_true', help='long descriptions')])        
     def do_ls(self, arg, opts):