oracle 10g pl/sql学习之update语句

create table t1(

 id number,

 name  varchar2(10)

);

 

create table t2(

 id number,

 name  varchar2(10),

 loc      varchar2(20)

);

 

 

insert into t1 values(1,'a');

insert into t1 values(2,'b');

insert into t1 values(3,'c');

 

insert into t2 values(1,'','a1');

insert into t2 values(2,'','b2');

insert into t2 values(3,'','c3');

 

 

现在t2表中的name字段要根据t1表中的name更新；

update t2 set name=(select name from t1 where t1.id=t2.id) where   exists (

select id from t1 where t2.id=t1.id);

 

 

select * from t2

id name loc

1 a a1
2 b b2
3 c c3