Question

oracle中怎样把一个表中某列字段复制到另一个表中去

有两个表 stuinfo 和tbl_detailinfo两个表，现在想把tbl_detailinfo表中photo字段复制到stuinfo表中，两个表中stuinfo中的ID字段和tbl_detailinfo表中的NO字段等值，我试了update stuinfo set stuinfo.photo=(select tbl_detailinfo.photo from tbl_detailinfo) where stuinfo.id = tbl_detailinfo.no;这句，结果提示tbl_detailinfo.no标示符无效，请问这个拷贝该怎样用sql语句实现啊

Answer 1

update stuinfo t1
set t1.photo = (
select t2.photo from tbl_detailinfo t2
where t1.id = t2.no
)
where exists (
select t2.photo from tbl_detailinfo t2
where t1.id = t2.no
)

Answer 2

insert
into
新表(字段1,字段2,字段3)
select
字段1,字段2,字段3
from
旧表;
commit;
确定新表里没被插入的字段有默认值或者不为空，否则报错

Answer 3

update stuinfo set stuinfo.photo=(select tbl_detailinfo.photo from tbl_detailinfo where stuinfo.id = tbl_detailinfo.no)