OracleDML-QueryExec.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 DML
    countryCode: str = "BD"
    countryName: str = "Bangladesh"
    regionID: int = 3
    cursor = connection.cursor()
    cursor.execute(
        """INSERT INTO COUNTRIES
        (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
        VALUES (:cCode, :cName, :rId)""",
        cCode=countryCode, cName=countryName, rId=regionID
    )
    connection.commit()
    print("Insertion successful")
    connection.close()

if __name__ == '__main__':
    main()