How to Batch Update association tables in Oracle

In SQL Server, the bulk update of the associated tables can be reviewed here:

Http://www.cnblogs.com/downmoon/archive/2007/12/29/1019832.html

Oracle did not find a good grammar, temporarily use this:

Update employee  Set hrdeptname=
(select D.deptname from DEPARTMENT d
where Rownum=1 and d.deptid= Employee.hrdeptid
)

Corresponding SQL Server syntax:

Update employee set Hrdeptname=d.deptname from
DEPARTMENT  D  INNER join employee E on  E.hrdeptid=d. DeptID
where 1=1;

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/