Procedure

作者: jmyang1518 | 来源:发表于2018-12-10 09:44 被阅读0次

    DECLARE
        VIN_SIT VARCHAR2(17) := '****************';
    BEGIN
        DELETE FROM aaa.fact_INstall_unit WHERE vin=VIN_SIT;
        COMMIT;
        DELETE FROM aaa.ig_prm_activity WHERE vin=VIN_SIT;
        COMMIT;
        DELETE FROM bbb.FACT_INSTALL_UNIT_STG WHERE vin=VIN_SIT;
        COMMIT;
        DELETE FROM bbb.vehicle_invoice_stg t WHERE t.vin=VIN_SIT;
        COMMIT;
        DELETE FROM aaa.vehicle_invoice WHERE vin=VIN_SIT;
        COMMIT;
      Delete From aaa.CDR_FULLLOAD Where vin=VIN_SIT;
      COMMIT;
      Delete From aaa.ONOFF_REQUEST_INFOTAINMT Where request_id in (Select REQUEST_ID From aaa.onoff_request_vehicle Where vin =VIN_SIT);
      COMMIT;
      Delete From aaa.ONOFF_REQUEST Where request_id in (Select REQUEST_ID From aaa.onoff_request_vehicle Where vin =VIN_SIT); 
      COMMIT;
    END;
    

    相关文章

      网友评论

          本文标题:Procedure

          本文链接:https://www.haomeiwen.com/subject/gzzlhqtx.html