如何在oracle下用一个表更新另一个表（急用!）

[YoukyJo]

我写的是
update student
set student.name = student1.name,
student.age = student1.age
from student,student1
where student.id = student1.id;
这个句子在sql server 2000下完全通过，
就是在oracle通不过
提示原因是sql命令未正确结束
请问高手是什么原因？
或者还有其他方法？

[deepbluesea]

update student
set student.name = (select name from student1 where student1.id=student.id),
student.age = (select age from student1 where student1.id=student.id)

oracle大概要这样写

[smartzhang]

update student
set (student.name,student.age)
(select name, age from student1
where student.id = student1.id)
where student.id = student1.id;