- #!/usr/bin/env python
- import time
- start = time.clock()
- import cx_Oracle
- tns = cx_Oracle.makedsn('127.0.0.1', '1534', 'dsn')
- db = cx_Oracle.connect('username', 'password', tns)
- def sqlSelect(sql, db):
- cur=db.cursor()
- cur.execute(sql)
- result=cur.fetchall()
- cur.close()
- return result
- sql_1 = " "
- sql_2 = " "
- sql_3 = " "
- sql_list = [sql_1, sql_2, sql_3]
- for sql in sql_list:
- result = sqlSelect(sql, db)
- print(result[0][0])
- end = time.clock()
- print("\nRunning time: %f s" % (end - start))
来源: http://www.phpxs.com/code/1009959/