Python cx_Oracle

cx_Oracle was obsoleted by python-oracledb in 2022.

Python-oracledb uses the same Python DB API as cx_Oracle, and has many new features.

Install with:

python -m pip install oracledb

Usage is like:

import getpass
import oracledb

un = 'scott'
cs = 'localhost/orclpdb1'
pw = getpass.getpass(f'Enter password for {un}@{cs}: ')

with oracledb.connect(user=un, password=pw, dsn=cs) as connection:
    with connection.cursor() as cursor:
        sql = 'select systimestamp from dual'
        for r in cursor.execute(sql):
            print(r)

The source code for python-oracledb is at github.com/oracle/python-oracledb.