OracleDDL-QueryExec-Two.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
    minSalary: int = 15000
    maxManagerID: int = 200
    cursor = connection.cursor()
    cursor.execute(
        """SELECT FIRST_NAME, LAST_NAME FROM EMPLOYEES
            WHERE SALARY > :sal AND MANAGER_ID < :man""",
        sal=minSalary, man=maxManagerID
    )

    # Printing output
    for fname, lname in cursor:
        print("{0} {1}".format(fname, lname))
    
    connection.close()    

if __name__ == '__main__':
    main()