python 利用oracledb连接oracle

import oracledb

# 一般情况会在此处添加oracle的安装路径，避免报错
oracledb.init_oracle_client(lib_dir=r"E:/xxx/instantclient_11_2_64/")

# 连接参数
dsn = oracledb.makedsn(
    host='11.22.33.44',  # 主机名或IP
    port='1521',      # 端口，默认1521
    service_name='xxx'  # 服务名
)

connection = oracledb.connect(
    user = "xxx",
    password = "xxx",
    dsn = dsn)

cursor = connection.cursor()
cursor.execute("select * from dual")

# 获取所有结果
for result in cursor:
    print(result)

cursor.close()
connection.close()