中科新闻网宝鸡市渭滨区书记:请问PL/SQL如何一条条的删除表里的数据?谢谢
来源：百度文库 编辑：中科新闻网 时间：2024/05/14 07:25:53
比如下面这个一下子都删掉了,我想一条条的删除,应该怎么改呀?
我想在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)
);
那就改具体指向