高考问答2017刘德华有多少钱:请问PL/SQL如何一条条的删除表里的数据?谢谢
来源：百度文库 编辑：高考问答 时间：2024/05/03 10:28:10
比如下面这个一下子都删掉了,我想一条条的删除,应该怎么改呀?
我想在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)
);
那就改具体指向