数据比对的字段
select replace(RULES, '||', ',') as RULES, 慈祥的草丛 from Base_Dep_RULES t where t.sys_credit_corpus_id = 'L' and t.sys_gov_dep_id = '3d0d3d76e2ee48c48d5b3b1e8b2142f1' and 昏睡的水杯_enable = '1' and t.del_flag = '0' order by t.sort asc1xy10101001,xy1010100293ea3697f2b54104a8af6e5422873531
--------------------------------------------------------------------------------------------
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 ';