alter table GIC_EXCEED_STOCK_SHARE_APPLY add (auditmsg varchar2(100));
merge into cts_api_setting_prd a using
(select ,b.service_code,b.service_name,b.method from cts_api_setting b)c
on (a.service_name=c.service_name)
when matched then update set =,a.service_code=c.service_code,a.method=c.method
update CUST_ACCOUNT_SOURCE_NEW_TEST set in_top=1,menu_location=2,
target_type='vue',menu_type=1,keep_alive=0
merge into CUST_ACCOUNT_SOURCE_NEW_TEST a using
(select b.* from CUST_ACCOUNT_SOURCE_NEW b)b
on (a.source_name=b.source_name)
when matched then update
set a.systemtype=b.systemtype,
a.url=b.url,
a.in_top=b.in_top,
a.menu_location=b.menu_location,
a.vue_path=b.vue_path,
a.frame_path=b.frame_path,
a.target_type=b.target_type,
a.menu_type=b.menu_type,
a.menu_code=b.menu_code,
a.keep_alive=b.keep_alive
