OracleDDL-QueryExec-One.py

import cx_Oracle

def main():
    # Variables
    username: str = "HR"
    password: str = "<YOUR_PASSWORD>"
    host: str = "localhost"
    service: str = "XE"

    # Connection establishing
    connection = None
    try:
        connection = cx_Oracle.connect(
            username,
            password,
            "{0}/{1}".format(host, service)
        )
        print("Connection successful")
    except cx_Oracle.DatabaseError as e:
        print(e)

    # Executing DDL
    cursor = connection.cursor()
    cursor.execute("SELECT FIRST_NAME, LAST_NAME FROM EMPLOYEES")

    # Printing output
    for i in cursor:
        print(i)
        
    connection.close()        

if __name__ == '__main__':
    main()