{{ message }}
oracle/python-cx_Oracle
Folders and files
| Name | Name | Last commit date | ||
|---|---|---|---|---|
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
 |  | |||
Repository files navigation
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.