表里面有1000多条数据，不能一条条的update哦update simple1 set name = (select name from simple2 where simple2.id = simple1.id); update simple1 a set a.name =(select b.name from simple2 b where a.id=b.id) update simple1 set name = (select name from simple2 where simple2.id = simple1.id); 1、2楼写的条件语句（如select b.name from simple2 b where a.id=b.id） 均报’a‘.’id‘标识符无效或者 'simple'.'id'标识符无效
SQL code:
create table simple1 (id number, name varchar2(20)); create table simple2 (id number, name varchar2(20));
insert into simple1 values (1, 'Tom'); insert into simple1 values (2, 'Jack'); insert into simple1 values (3, 'Andy');
insert into simple2 values (1, 'Amy'); insert into simple2 values (2, 'Mary'); insert into simple2 values (3, 'Cindy');
update simple1 set name = (select name from simple2 where simple2.id = simple1.id);
oracle 11g 安装 01092 错误, 日志信息： [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
eclipse 3.3启动web工程，要连接oracle9i数据库报 严重: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off cli ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 上面一个简单的SQL,执行时间2.6� ......
