update student A
set (A
(select B
from newstudent B
where B
and A
)
where exists (select
from newstudent B
where B
and A
);
From:http://tw.wingwit.com/Article/program/Oracle/201311/18385.html
update student A
set (A
(select B
from newstudent B
where B
and A
)
where exists (select
from newstudent B
where B
and A
);