oracledb_connect_and_query_database_version.py

1import oracledb
2import os
3
4# Set these environment variables or replace them with your database 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 to the database
10connection = oracledb.connect(user=un, password=pw, dsn=cs)
11
12with connection.cursor() as cursor:
13    # Execute a simple query
14    sql = """select sysdate from dual"""
15    for row in cursor.execute(sql):
16        print(row)
17
18# The connection is automatically closed when the script ends or 
19# you can explicitly close it:
20# connection.close()