python在windows下连接远程Oracle并查询

首先需要去oracle官网下载客户端
https://download.oracle.com/otn_software/nt/instantclient/19500/instantclient-basic-windows.x64-19.5.0.0.0dbru.zip

    # set env for Oracle client
    LOCATION = r"C:\NotBackedUp\instantclient_19_3" # 客户端路径
    os.environ["PATH"] = LOCATION + ";" + os.environ["PATH"]
    # print(start_date,end_date)
    try:
        con = cx_Oracle.connect(用户,密码,连接串)
        cursor = con.cursor()
        getFirstRecord = f"select语句"
        cursor.execute(getFirstRecord)
        firstRecord = cursor.fetchall()