1.更新表CIS_ORGINFO_POSITION 的列cop_orgcode为cis_organinfo的列co_orgcode
update cis_orginfo_position set cop_orgcode=(select tt.co_orgcode from cis_organinfo tt where tt.co_orgaddr=cop_orgname and rownum=1 )
2.将表cis_orginfo_position的列cop_orgcode插入到表CIS_CAPACITY中
insert into CIS_CAPACITY (csc_id,csc_refid)
select sys_guid(),cop_orgcode from cis_orginfo_position