--更新生产基础字段 merge into city_cfg_data_column_common cf1 using city_cfg_data_column_common2 cf2 on (cf1.resourceid = cf2.resourceid) when matched then update set cf1.template_type = cf2.template_type, cf1.chinese_name = cf2.chinese_name, cf1.column_name = cf2.column_name, cf1.column_type = cf2.column_type, cf1.column_size = cf2.column_size when not matched then insert (cf1.resourceid,cf1.template_type,cf1.chinese_name,cf1.column_name,cf1.column_type,cf1.column_size ,cf1.is_can_edit,cf1.is_unique,cf1.is_can_cover,cf1.show_order) values (cf2.resourceid,cf2.template_type,cf2.chinese_name,cf2.column_name,cf2.column_type,cf2.column_size ,cf2.is_can_edit,cf2.is_unique,cf2.is_can_cover,cf2.show_order)
set column oracle,Oracle 用一个表字段更新另一个表字段三种方法
最新推荐文章于 2022-12-13 09:13:55 发布