数据比对的过程

数据比对的字段

select replace(RULES, '||', ',') as RULES, t.id
               from Base_Dep_RULES t
              where t.sys_credit_corpus_id = 'L'
                and t.sys_gov_dep_id = '3d0d3d76e2ee48c48d5b3b1e8b2142f1'
                and t.is_enable = '1'
                and t.del_flag = '0'
              order by t.sort asc


1	xy10101001,xy10101002	93ea3697f2b54104a8af6e5422873531

--------------------------------------------------------------------------------------------
select "TABLE" column_value from "TABLE"(SPLIT('xy10101001,xy10101002', ','))


1 xy10101001
2 xy10101002


-----------------------------------------------------------------------------------------------


 select t.alias_name
             v_alias_name
            from Base_Main_Cloumn t
           where 
           upper(t.en_name) = upper('xy10101002') 
           and t.sys_credit_corpus_code='L'
1 NAME
2 L_CREDIT_CODE
--------------------------------------------------------------------------------------------------
创建临时表
select * from BASE_TEMP_TABLE 
1 DFC408E61AF7493B82EE4159B8E17A9C IMWYSQGVVTASOGDLXLKDCPKDNXSKTU 2017-08-16 15:25:36.0 PROC_CREATE_MATTERS_TABLE_TMP
-----------------------------------------------------------------------------------------------------
比对字段


a.xy10101001 = b.name  a.xy10101002 = b.L_CREDIT_CODE
-------------------------------------------------------------------------------------------------------
建立临时表
包含的字段 id ,code 通过过滤后的字段
--------------------------------------------------------------------------------------------------------
修改比对字段




如果，存在，比对成功
 update dep_l_000101 a set a.m_010101 = b.code , a.THAN_DATE = sysdate , a.IS_MATE = 1, a.rule_id = 'IMWYSQGVVTASOGDLXLKDCPKDNXSKTU' from '  ' b where a.id = b.id ';

--------------------------------------------------------------------------------------------
select "TABLE" column_value from "TABLE"(SPLIT('xy10101001,xy10101002', ','))


1 xy10101001
2 xy10101002


-----------------------------------------------------------------------------------------------


 select t.alias_name
             v_alias_name
            from Base_Main_Cloumn t
           where 
           upper(t.en_name) = upper('xy10101002') 
           and t.sys_credit_corpus_code='L'
1 NAME
2 L_CREDIT_CODE
--------------------------------------------------------------------------------------------------
创建临时表
select * from BASE_TEMP_TABLE 
1 DFC408E61AF7493B82EE4159B8E17A9C IMWYSQGVVTASOGDLXLKDCPKDNXSKTU 2017-08-16 15:25:36.0 PROC_CREATE_MATTERS_TABLE_TMP
-----------------------------------------------------------------------------------------------------
比对字段


a.xy10101001 = b.name  a.xy10101002 = b.L_CREDIT_CODE
-------------------------------------------------------------------------------------------------------
建立临时表
包含的字段 id ,code 通过过滤后的字段
--------------------------------------------------------------------------------------------------------
修改比对字段




如果，存在，比对成功
 update dep_l_000101 a set a.m_010101 = b.code , a.THAN_DATE = sysdate , a.IS_MATE = 1, a.rule_id = 'IMWYSQGVVTASOGDLXLKDCPKDNXSKTU' from '  ' b where a.id = b.id ';