python 连接oracle

安装模块cx-Oracle

pip install cx-Oracle

python环境：

# pip list
Package             Version
------------------- ---------
appdirs             1.4.4
certifi             2021.5.30
charset-normalizer  2.0.4
cx-Oracle           8.2.0
distlib             0.3.1
filelock            3.0.12
idna                3.2
importlib-metadata  4.0.1
importlib-resources 5.1.4
pip                 21.1.3
py-zabbix           1.1.7
PyMySQL             1.0.2
redis               3.5.3
requests            2.26.0
setuptools          40.6.2
six                 1.16.0
typing-extensions   3.10.0.0
urllib3             1.26.6
virtualenv          20.4.7
zipp                3.4.1

示例：

# -*- coding: utf-8 -*-
import cx_Oracle

conn=cx_Oracle.connect('user/passwd@ip:1521/orcl')
cursorObj=conn.cursor()
sql="select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual"
sql1="select file_name,status from dba_data_files"
r1=cursorObj.execute(sql1)
for i in r1:
    print(i)
cursorObj.close()
conn.close()

运行结果：