Question

oracle如何删除多行数据

在这个表里"GEO3D"."DKSJ" 我想删除当"HOLEID"分别=1,201,205，309,207,901,405所在行数据时，SQL语句要怎么写啊，谢谢哈，我没有分了

Answer 1

delete from GEO3D.DKSJ
where HOLEID in(1,201,205,309,207,901,405);

Answer 2

delete GEO3D.DKSJ where HOLEID in (1,201,205,309,207,901,405);