数据比对的过程

你的名字 2022-05-23 08:05 126阅读 0赞

数据比对的字段

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 ';