python 连接oracle

安装模块cx-Oracle

pip install cx-Oracle

示例：

# -*- 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"  sql语句
sql1="select file_name,status from dba_data_files"  sql语句
r1=cursorObj.execute(sql1)   执行sql语句
for i in r1:
    print(i)
cursorObj.close() 关闭游标
conn.close()  关闭数据库