解决方案 »
- rman如何做数据库恢复?
- (ora-06502 pl sql 数字或值错误 字符串缓冲区太小)(ORA-03127 no new operations allowed until ..)
- oracle如何复制远程表更新的数据,5点钱在线等···
- 动态 analyze 的权限不足问题
- 关于外连接的问题,高手帮忙!
- 关于获取前条记录字段的简单问题
- 动态条件的UPDATE语句问题?
- 如何查询当前用户有操作权限的所有表的信息?
- 请问我想让SQL Server与Oracle中的指定表的指定字段保持同步,是否可行?应该如何做?
- 关于row_number() over的问题
- SQL语句问题
- 记录补零的SQL语句
update emp a set age=(select age from eage b where a.name=b.name)
where exists(select 1 from eage c where a.name=c.name)
insert into emp(age) select empno , age from eage
或是你更新原有EMPNO的age列?
update emp set age = (select age from eage n where n.empno = m.enpno)
from emp m where exists (select 1 empno from eage where empno = m.empno)或者
update emp set age = (select age from eage n where n.empno = m.enpno)
from emp m where m.empno in (select empno from eage)
where exists(select 1 from eage where emp.ename=ename)