oracledb_quickstart_connect_query_database_version.py

1import oracledb
2import os
3
4# Use environment variables or replace with your actual credentials
5# Generally: "user/password@host:port/service_name"
6un = os.environ.get('PYTHON_USERNAME', 'hr')
7pw = os.environ.get('PYTHON_PASSWORD', 'welcome')
8cs = os.environ.get('PYTHON_CONNECTSTRING', 'localhost:1521/xe')
9
10# Create a connection
11connection = oracledb.connect(user=un, password=pw, dsn=cs)
12
13# Use a cursor to execute SQL
14with connection.cursor() as cursor:
15    sql = """SELECT sys_context('userenv', 'db_name') FROM dual"""
16    for row in cursor.execute(sql):
17        print(row)
18
19# Connection is closed automatically when the 'with' block ends or 
20# if you explicitly call connection.close()
21connection.close()