python连接Oracle

安装cx_Oracle
pip install cx_Oracle
创建数据库连接
import cx_Oracle

connection = cx_Oracle.connect("user", "password", "localhost/database")

cursor = connection.cursor()
cursor.execute("""
SELECT first_name, last_name
FROM employees
WHERE department_id = :did AND employee_id > :eid""",
did = 50,
eid = 190)
for fname, lname in cursor:
print("Values:", fname, lname)

转载于:https://www.cnblogs.com/lovemyqin/p/9932658.html