oracle 一张表复制到另一张表以及已经复制的表之间的批量更新

模拟两张表student和student1,都有name,yuwen,shuxue三个字段，name为主键，

目标：studen1表复制到student表和student1到student的更新

复制语句：insert into  student(select * from student1)

批量更新语句：update (select student.shuxue a1,student1.shuxue b1,student.yuwen a2 ,student1.shuxue b2 from student,student1 where student.name=student1.name) set a1=b1,a2=b2;