suvene · July 12, 2011 15:31
diff --git a/update from other table b/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
    );
	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
	);