... one table based on values in another table : Update subquery « Insert Delete Update « Oracle PL / SQL.
www.java2s.com