Gist for https://cjones-oracle.medium.com/installing-the-python-driver-for-oracle-databas-in-vs-code-df73d6eaf071

demo.py

import getpass
import os
import traceback
import oracledb

un = ''
cs = ''
pw = getpass.getpass(f'Enter password for {un}: ')

try:

    connection = oracledb.connect(user=un, password=pw, dsn=cs)

    with connection.cursor() as cursor:
        sql = """select systimestamp from dual"""
        for r, in cursor.execute(sql):
            print(r)

except oracledb.Error as e:
    error, = e.args
    print(error.message)
    traceback.print_tb(e.__traceback__)