在Python中连接到2个Oracle数据库

pip install cx_Oracle

import cx_Oracle

# 连接到第一个Oracle数据库
conn1 = cx_Oracle.connect('username1/password1@hostname1:port1/service_name1')

# 连接到第二个Oracle数据库
conn2 = cx_Oracle.connect('username2/password2@hostname2:port2/service_name2')

# 创建游标对象
cursor1 = conn1.cursor()
cursor2 = conn2.cursor()

# 执行查询操作
cursor1.execute('SELECT * FROM table1')
cursor2.execute('SELECT * FROM table2')

# 获取查询结果
result1 = cursor1.fetchall()
result2 = cursor2.fetchall()

# 关闭游标和连接
cursor1.close()
cursor2.close()
conn1.close()
conn2.close()