Oracle复制列值
要求叙述:在测试环境中已存有的表格中加上1个字段名,并将表格中部分统计数据的这某列开展了手工制作加上统计数据,如今期待能在宣布自然环境中加上这一字段名后,并把将测试环境已存有的值拷贝到宣布自然环境。 因为测试环境和宣布自然环境的表构造相同,可是沒有在相同库,因此解决方案是:
1、在测试环境在建1个Database links
2、根据给出句子开展拷贝:
UPDATE ext_organinfo eop
SET eop.thumbnailmap = (SELECT eo.thumbnailmap
FROM ext_organinfo@puam eo
WHERE eo.organ_id = eop.organ_id)
WHERE eop.organ_id IN (SELECT eo.organ_id
FROM ext_organinfo@puam eo
WHERE eo.thumbnailmap IS NOT NULL )
相关文章
- 4条评论
- 拥嬉南忆2022-05-29 13:16:58
- sp; WHERE eo.thumbnailmap IS NOT NULL )
- 忿咬聊慰2022-05-29 23:40:39
- ; FROM ext_organinfo@puam eo  
- 舔夺锦欢2022-05-29 15:18:36
- sp; WHERE eo.organ_id = eop.organ_id)WHERE eop.organ_id IN (SELECT eo.organ_id &nbs
- 北槐羡兔2022-05-29 18:37:03
- p; FROM ext_organinfo@puam eo &nb