def createdb(dbName,tbName,sql): rowcount=0 db = Oracledbx.DealOracle(login) db.connectdb() cusor = db.newcur() try: sql0="select * from all_all_tables where owner=upper('"+dbName+"') and table_name=upper('"+tbName+"')" find_result=finddb(sql0) if find_result==0: result = db.exec_sql(sql, cusor) print("create info:table create successful!") else: print("create info:table is exist!") except: traceback.print_exc() db.closecur(cusor) db.closedb() def createdb2(sql): rowcount=0 db = Oracledbx.DealOracle(login) db.connectdb() cusor = db.newcur() try: db.exec_sql(sql, cusor) except: traceback.print_exc() db.closecur(cusor) db.closedb() def demo(): creSql = "DROP TABLE ODSPMART.T_MID_JT_INTERFACE_UP
Python 中写多条SQL语句的写法
最新推荐文章于 2023-05-28 20:44:10 发布
该博客介绍如何在Python中通过函数createdb和createdb2执行多条Oracle SQL语句,包括创建和删除表格,以及为表格和列添加注释。示例展示了如何处理包含多个操作的SQL字符串,通过分割执行每一句。
摘要由CSDN通过智能技术生成