update tb_cm_serv d
set d.dp_id =
(
select trim(dp_id)
from asl_ogh_cust
where trim(dhhm)=d.acc_nbr
)
where d.serv_id in (select serv_id from asl_temp);update tb_cm_serv d
set d.dp_id =
(
select trim(dp_id)
from asl_ogh_cust
where trim(dhhm)=d.acc_nbr
)
where exists
( select 'x' from asl_temp e
where d.serv_id = e.serv_id );
set d.dp_id =
(
select trim(dp_id)
from asl_ogh_cust
where trim(dhhm)=d.acc_nbr
)
where d.serv_id in (select serv_id from asl_temp);update tb_cm_serv d
set d.dp_id =
(
select trim(dp_id)
from asl_ogh_cust
where trim(dhhm)=d.acc_nbr
)
where exists
( select 'x' from asl_temp e
where d.serv_id = e.serv_id );
解决方案 »
- 汉字名字加双引号和不加双引号有区别吗
- ORACLE 11GR2 DB安装在A服务器,在B电脑安装ORACLE CLIENT,无法链接服务器A
- Oracle to_date函数问题
- Oracle Sql语句性能
- 求教关于sql时间问题
- 求助,这条语句那里错了
- 请教一个commit=y及INI文件里参数的问题?
- 数据库中碰到奇怪的事情???
- 在线等待:SQL下的CASE..END语句在ORACLE8.05下怎么实现
- 我的远程数据link出错!! 如何把一个数据库中的部分记录通过sql语句导入到另一个数据库??
- 有没有类似于SQL Server中的事件跟踪器(Profiler)的Oracle第三方工具?
- 小弟明天考oracle,弄到复习题,不会!!!哪位大侠相救?100分送上
set d.dp_id=(select trim(dp_id) from asl_ogh_cust where trim(dhhm)=d.acc_nbr )
where exists(select 1 from asl_temp b where d.serv_id=b.serv_id)