Connect to oracle database using python

oracle_connect.py

import cx_Oracle

# Connect to the database
connection = cx_Oracle.connect("user", "password", "host:port/service_name")

# Create a cursor
cursor = connection.cursor()

try:
    # Execute a statement
    cursor.execute("select * from table")

    # get column names
    col_names = [row[0] for row in cursor.description]

    # Fetch all the rows
    rows = cursor.fetchall()

    # Print the rows
    for row in rows:
        print(dict(zip(col_names, row)))

except Exception as e:
    raise e

finally:
    # Close the cursor
    cursor.close()

    # Close the connection
    connection.close()