UPDATE TABLE A FROM TABLE B IN ORACLE

Hi all

A little big problem, i always forget in oracle how to do an update on a table from data on another table, so i fix it in my blog :

update table1

set field = (

select field

from table2

where table2.id = table1.id

);

Stay tuned.