Question

oracle如何删除查询到的数据

表 2_2 包含 select * from 1_1 所查询到的所有数据
问下如何在表 2_2 中 删除 select * from 1_1 所查询到的所有数据
在线等 谢谢

Answer 1

有id好说 delete from 2_2 WHERE id in (select id from 1_1)
没有就比较麻烦
delete from 2_2 where exists （select 1 from 1_1 where 1_1.所有项目=2_2.所有项目）

追问

delete from 2_2 select * from 1_1 这样写 可不可呢

追答

不能这么写，语法不对

Answer 2

delete from (select * from 1_1 wher 1=1) a;
commit;
就可以了

Answer 3

delete from 2_2 where exists (select 1 from 1_1 where 2_2.字段=1_1.字段)

Answer 4

delete from 1_1