一、下载cx_Oracle
1、命令安装
pip install cx_oracle
2、下载安装
2.1、http://cx-oracle.sourceforge.net/
-
cx_Oracle-5.3-12c.win-amd64-py3.6-2.exe
-
5.3:指cx_Oracle版本;
-
amd64:指操作系统是64位 ;
-
py3.6:指python是3.6版本
2.2、将上面oracle 安装包里的oci.dll、 oraocci12.dll、oraociei12.dll 这三个文件拷贝到KaTeX parse error: Expected 'EOF', got '\Lib' at position 7: python\̲L̲i̲b̲\site-packages目…python 根目录下
二、实例
import cx_Oracle
db = cx_Oracle.connect(globaDB.dbuat)
time.sleep(1)
cursor = db.cursor()
sql = "select sms_code from (select sms_code from opp_busi_sms order by oper_time desc) where rownum=1"
self.my_print_info(sql)
time.sleep(1)
rs = cursor.execute(sql)
li = rs.fetchall()
time.sleep(1)
# # 打印业务单号,此处引用正则来过滤到数字,去掉其它字符
code = li[0][0]
# code = li[3:9]
print(code)
db.close()
time.sleep(1)