查人人中国名人网手机显卡驱动下载:请问PL/SQL如何一条条的删除表里的数据?谢谢
来源：百度文库 编辑：查人人中国名人网 时间：2024/04/29 21:03:46
比如下面这个一下子都删掉了,我想一条条的删除,应该怎么改呀?
我想在proc里面用的．
DELETE FROM TBL_1
WHERE filed1 IN
(SELECT filed2 FROM TBL_1
WHERE time_start <= SYSDATE - 10
AND time_end IN (SELECT time_all FROM TBL_2)
);
我想在proc里面用的．
DELETE FROM TBL_1
WHERE filed1 IN
(SELECT filed2 FROM TBL_1
WHERE time_start <= SYSDATE - 10
AND time_end IN (SELECT time_all FROM TBL_2)
);
那就改具体指向