努力改变自己的语句,Oracle数据库数据修改语句
答案:1 悬赏:40 手机版
解决时间 2021-04-05 08:17
- 提问者网友：自食苦果
- 2021-04-05 02:15
努力改变自己的语句,Oracle数据库数据修改语句
最佳答案
- 五星知识达人网友：猎心人
- 2021-04-05 03:28
表 [email protected] 有没有主键？
有，如下
update [email protected]
set rsc_status_cd=43
where a.主键 in (
select a.主键 from [email protected] a,[email protected] b,[email protected] c,[email protected] d
where a.an_type_cd=b.an_type_cd
and a.rsc_status_cd=c.rsc_status_cd
and a.pool_id=d.pool_id
and a.area_id='8'
and a.an_type_cd='101'
and (a.phone_number like '%000'
or a.phone_number like '%111'
or a.phone_number like '%222'
or a.phone_number like '%333'
or a.phone_number like '%444'
or a.phone_number like '%555'
or a.phone_number like '%666'
or a.phone_number like '%777'
or a.phone_number like '%888'
or a.phone_number like '%999'
)
and a.rsc_status_cd in ('1')
)
)
有，如下
update [email protected]
set rsc_status_cd=43
where a.主键 in (
select a.主键 from [email protected] a,[email protected] b,[email protected] c,[email protected] d
where a.an_type_cd=b.an_type_cd
and a.rsc_status_cd=c.rsc_status_cd
and a.pool_id=d.pool_id
and a.area_id='8'
and a.an_type_cd='101'
and (a.phone_number like '%000'
or a.phone_number like '%111'
or a.phone_number like '%222'
or a.phone_number like '%333'
or a.phone_number like '%444'
or a.phone_number like '%555'
or a.phone_number like '%666'
or a.phone_number like '%777'
or a.phone_number like '%888'
or a.phone_number like '%999'
)
and a.rsc_status_cd in ('1')
)
)
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯