...
Code Block | ||
---|---|---|
| ||
"""Example of a select query to an Oracle Database""" import cx_Oracle # Establish the database connection dbh = cx_Oracle.connect(user='AIS_RPC', password='********', dsn="hydra2" ) # Obtain a cursor and execute query num_N_SUBJECT_ID = 100 cursor = dbh.cursor() cursor.execute("""SELECT VC_SUBJ_TYPE_NAME, VC_CODE FROM SI_V_SUBJECTS WHERE N_SUBJECT_ID = 100:num_N_SUBJECT_ID""", [num_N_SUBJECT_ID]) # Fetch column names and data as an associative array columns = [i[0] for i in cursor.description] data = [dict(zip(columns, row)) for row in cursor.fetchall()] # Print data for row in data: print(f"VC_SUBJ_TYPE_NAME: {row['VC_SUBJ_TYPE_NAME']}") print(f"VC_CODE: {row['VC_CODE']}") # Close the database connection dbh.close() |
...