sql批量执行删除操作?

dashorc

pwd
/tmp
cat 1.sql
delete from ki where sn in '364VJN6827';
delete from ki where sn in '364VJN64YK';
delete from ki where sn in '364VJN6502';
delete from ki where sn in '364VJN67TH';
delete from ki where sn in '364VJN64CW';
delete from ki where sn in '364VJN6850';
delete from ki where sn in '364VJN67RK';
delete from ki where sn in '364VJN6751';
delete from ki where sn in '364VJN66Z7';
delete from ki where sn in '364VJN6680';
delete from ki where sn in '364VJN6748';
delete from ki where sn in '364VJN67QQ';
delete from ki where sn in '364VJN67T7';
然后sql命令下执行@/tmp/1.sql
只能删除第一条记录,后面的都不能删除?
有高手帮忙看看吗?谢谢了

flutter

加上 force noprompt试试.

luffy.deng

不用提交么？

dashorc

force noprompt是什么意思啊,具体格式是什么样子的,高手请解释得详细一点!

bobofreebird

应该要在每个delete语句后加 commit;

yslaoniu

delete from ki where sn in '364VJN6827','364VJN64YK','364VJN6502','364VJN67TH','364VJN64CW','364VJN6850','364VJN67RK', '364VJN6751','364VJN66Z7','364VJN6680','364VJN6748','364VJN67QQ','364VJN67T7');
commit;

为什么不这样写

wq_1228

把分号改称回车加下划线（/）执行一下试试

jiangf

这批delete语句都在一个会话中,后面不要加commit吧,
楼主可以在删除的过程中查看一下v$locked_object;

imtj

我也赞成楼上的说法，看看是不是对象LOCK了

rockytom

原帖由 yslaoniu 于 2008-7-17 22:31 发表
delete from ki where sn in '364VJN6827','364VJN64YK','364VJN6502','364VJN67TH','364VJN64CW','364VJN6850','364VJN67RK', '364VJN6751','364VJN66Z7','364VJN6680','364VJN6748','364VJN67QQ','364VJN67T7 ...

同问!