UPDATE TB_ADS_IB_COMMON a
SET (
a.SYSTEM_ID,
a.UCM_ID_C,
a.SERVICE_PL,
a.SITE_PROVINCE,
a.FE_CHANNEL,
a.FE_REGION,
a.ASSET_NUM,
a.REGION,
a.ACCOUNT_SEGMENT_LEVEL,
a.INSTALLED_AT_ALTERNATE_CUSTOMER_NAME,
a.MODALITY,
a.DI_US_LCS,
a.RGM,
a.RGM_SSO,
a.ZONE_MANAGER,
a.ZONE_MANAGER_SSO,
a.SVC_SALES,
a.SALES_SSO,
a.HEAD_SSO,
a.HEAD_NAME,
a.ZOM_SSO,
a.ZOM_NAME,
a.PSI_DESC,
a.CN_2ND_LEVEL_MODALITY,
a.SERIAL_NUM,
a.PSI_CODE_NEW,
a.PART_NUM_DESC,
a.INSTAL_DT,
a.WARRANTY_END_DT,
a.SERVICE_REGION,
a.INSTALLED_AT_CUSTOMER_NBR,
a.SITE_ID,
a.CFDA_NAME,
a.KEY_PRODUCT,
a.LST_UPD_DT,
a.STATUS,
a.ACCOUNT_SEGMENT_2ND_LEVEL,
a.INST_ADDRLINE3,
a.ASSET_STATUS,
a.COMMERCIAL_C_START,
a.COMMERCIAL_C_END,
a.SITE_CITY,
a.ENTERPRISE,
a.EQ_SEGMENT,
a.FE_NAME,
a.FE_SSO,
a.IB_TYPE,
a.MOD_1,
a.PRODUCT_SEGMENT,
a.PSI_CD,
a.WARRANTY_START_DT_OVERRIDE,
a.ZONE,
a.PO_NUMBER,
a.FAMILY_NAME,
a.SERVICEABLE_IB,
a.SERIES_2,
a.CONVT_RENEW_OPP_NEW,
a.TUBE_M,
a.SALES_ORDER_NUM,
a.TERRITORY_2,
a.UPDATE_TIME
) = (
SELECT
c.SYSTEM_ID,
c.UCM_ID_C,
c.SERVICE_PL,
c.SITE_PROVINCE,
c.FE_CHANNEL,
c.FE_REGION,
c.ASSET_NUM,
c.REGION,
c.ACCOUNT_SEGMENT_LEVEL,
c.INSTALLED_AT_ALTERNATE_CUSTOMER_NAME,
c.MODALITY,
c.DI_US_LCS,
c.RGM,
c.RGM_SSO,
c.ZONE_MANAGER,
c.ZONE_MANAGER_SSO,
c.SVC_SALES,
c.SALES_SSO,
c.HEAD_SSO,
c.HEAD_NAME,
c.ZOM_SSO,
c.ZOM_NAME,
c.PSI_DESC,
c.CN_2ND_LEVEL_MODALITY,
c.SERIAL_NUM,
c.PSI_CODE_NEW,
c.PART_NUM_DESC,
c.INSTAL_DT,
c.WARRANTY_END_DT,
c.SERVICE_REGION,
c.INSTALLED_AT_CUSTOMER_NBR,
c.SITE_ID,
c.CFDA_NAME,
c.KEY_PRODUCT,
c.LST_UPD_DT,
c.STATUS,
c.ACCOUNT_SEGMENT_2ND_LEVEL,
c.INST_ADDRLINE3,
c.ASSET_STATUS,
c.COMMERCIAL_C_START,
c.COMMERCIAL_C_END,
c.SITE_CITY,
c.ENTERPRISE,
c.EQ_SEGMENT,
c.FE_NAME,
c.FE_SSO,
c.IB_TYPE,
c.MOD_1,
c.PRODUCT_SEGMENT,
c.PSI_CD,
c.WARRANTY_START_DT_OVERRIDE,
c.ZONE,
c.PO_NUMBER,
c.FAMILY_NAME,
c.SERVICEABLE_IB,
c.SERIES_2,
c.CONVT_RENEW_OPP_NEW,
c.TUBE_M,
c.SALES_ORDER_NUM,
c.TERRITORY_2,
c.UPDATE_TIME
FROM TB_ADS_IB_COMMON_INCREMENTAL_BAK c
WHERE a.asset_num = c.asset_num
AND c.delete_flag = 0
AND ROWNUM <![CDATA[<= ]]> 1
)
WHERE EXISTS (
SELECT 1
FROM TB_ADS_IB_COMMON_INCREMENTAL_BAK c
WHERE a.asset_num = c.asset_num
AND c.delete_flag = 0
) 需要返回更新数量, oracle, 不能写存储过程, 现在数据量大很慢, 怎么优化一下
最新发布