update from other table

create table a(
  id number,
  val varchar2(20)
);
create table b(
  id number,
  val varchar2(20)
);

update a set
    val = (
      select val from b
      where b.id = a.id
    );