oracledb_basic_connection_and_query_quickstart.py

1import oracledb
2import os
3
4# Set these environment variables or replace with your actual credentials
5un = os.environ.get('PYTHON_USERNAME', 'hr')
6pw = os.environ.get('PYTHON_PASSWORD', 'welcome')
7cs = os.environ.get('PYTHON_CONNECTSTRING', 'localhost/orclpdb1')
8
9# Create a connection
10connection = oracledb.connect(user=un, password=pw, dsn=cs)
11
12# Use a cursor to execute a query
13with connection.cursor() as cursor:
14    sql = """SELECT sysdate FROM dual"""
15    for row in cursor.execute(sql):
16        print(row)
17
18# Connection is automatically closed when the script ends or use connection.close()