comparison sqlpyPlus.py @ 15:9c7df9f825a1

cleanup find
author devlinjs@FA7CZA6N1254998.wrightpatterson.afmc.ds.af.mil
date Tue, 18 Dec 2007 19:18:22 -0500
parents 1300a997d319
children 2776755a3a7e
comparison
equal deleted inserted replaced
14:1300a997d319 15:9c7df9f825a1
691 if options.has_key('insensitive'): 691 if options.has_key('insensitive'):
692 searchfor = "LOWER(text)" 692 searchfor = "LOWER(text)"
693 arg = arg.lower() 693 arg = arg.lower()
694 else: 694 else:
695 searchfor = "text" 695 searchfor = "text"
696 print "* from all_source where %s like %%%s%%" % (searchfor, arg)
697 self.do_select("* from all_source where %s like '%%%s%%'" % (searchfor, arg)) 696 self.do_select("* from all_source where %s like '%%%s%%'" % (searchfor, arg))
698 697
699 def do_describe(self, arg): 698 def do_describe(self, arg):
700 "emulates SQL*Plus's DESCRIBE" 699 "emulates SQL*Plus's DESCRIBE"
701 object_type, owner, object_name = self.resolve(arg.strip(self.terminator).upper()) 700 object_type, owner, object_name = self.resolve(arg.strip(self.terminator).upper())