set column oracle,Oracle 用一个表字段更新另一个表字段三种方法

--更新生产基础字段 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)