Py学习  »  Python

无法在python中使用cx_oracle合并表

William • 4 年前 • 1856 次点击  

我正在尝试使用cx_oracle合并两个表。 以下sql语言适用于sql developer tools:

 MERGE INTO ASBODS_SDDM_SCHEMA.EULA_DATA E
    USING (SELECT * FROM ASBODS_SDDM_SCHEMA.EULA_STG_DATA) ES
    ON (E.MASTER_METER_NBR = ES.MASTER_METER_NBR AND E.MASTER_ACCOUNT_NBR = ES.MASTER_ACCOUNT_NBR AND 
    E.METER_NBR = ES.METER_NBR AND E.ACCOUNT_NBR = ES.ACCOUNT_NBR AND E.EULA_DATA_TYPE_CD = ES.EULA_STG_DATA_TYPE_CD)
    WHEN MATCHED THEN
    UPDATE SET
    E.ACCEPTED_DT = ES.ACCEPTED_DT ,
    E.DECLN_OF_CONSENT_FLG = ES.DECLN_OF_CONSENT_FLG ,
    E.EULA_VERSION_NBR = ES.EULA_VERSION_NBR,
    E.SOFTWARE_VERSION_NBR = ES.SOFTWARE_VERSION_NBR,
    E.COMPANY_NM = ES.COMPANY_NM ,
    E.MACH_ID = ES.MACH_ID ,
    E.LOAD_DT = ES.LOAD_DT
    WHERE 
    E.MASTER_METER_NBR = ES.MASTER_METER_NBR AND E.MASTER_ACCOUNT_NBR = ES.MASTER_ACCOUNT_NBR AND 
    E.METER_NBR = ES.METER_NBR AND E.ACCOUNT_NBR = ES.ACCOUNT_NBR AND E.EULA_DATA_TYPE_CD = ES.EULA_STG_DATA_TYPE_CD

但当我将这个sql插入cx_或Cale时:

import cx_Oracle

try:
    con = cx_Oracle.connect('username/pwd@server')
    cursor = con.cursor()
    cursor.execute(''' MERGE INTO ASBODS_SDDM_SCHEMA.EULA_DATA E
    USING (SELECT * FROM ASBODS_SDDM_SCHEMA.EULA_STG_DATA) ES
    ON (E.MASTER_METER_NBR = ES.MASTER_METER_NBR AND E.MASTER_ACCOUNT_NBR = ES.MASTER_ACCOUNT_NBR AND 
    E.METER_NBR = ES.METER_NBR AND E.ACCOUNT_NBR = ES.ACCOUNT_NBR AND E.EULA_DATA_TYPE_CD = ES.EULA_STG_DATA_TYPE_CD)
    WHEN MATCHED THEN
    UPDATE SET
    E.ACCEPTED_DT = ES.ACCEPTED_DT ,
    E.DECLN_OF_CONSENT_FLG = ES.DECLN_OF_CONSENT_FLG ,
    E.EULA_VERSION_NBR = ES.EULA_VERSION_NBR,
    E.SOFTWARE_VERSION_NBR = ES.SOFTWARE_VERSION_NBR,
    E.COMPANY_NM = ES.COMPANY_NM ,
    E.MACH_ID = ES.MACH_ID ,
    E.LOAD_DT = ES.LOAD_DT
    WHERE 
    E.MASTER_METER_NBR = ES.MASTER_METER_NBR AND E.MASTER_ACCOUNT_NBR = ES.MASTER_ACCOUNT_NBR AND 
    E.METER_NBR = ES.METER_NBR AND E.ACCOUNT_NBR = ES.ACCOUNT_NBR AND E.EULA_DATA_TYPE_CD = ES.EULA_STG_DATA_TYPE_CD
     ''') 
    con.commit()
    
    except cx_Oracle.DatabaseError as e:
    print('There is problem with sql', e)

finally:
    if cursor:
        con.commit()
        cursor.close()
    if con:
        con.close()
    

它在linux中很长时间没有反馈,似乎一直在运行,不起作用。

有朋友能帮忙吗?

Python社区是高质量的Python/Django开发社区
本文地址:http://www.python88.com/topic/131397
文章 [ 1 ]  |  最新文章 4 年前