娇韵诗昆明专柜地址:请问PL/SQL如何一条条的删除表里的数据?谢谢

来源:百度文库 编辑:神马品牌网 时间:2024/07/14 12:57:04
比如下面这个一下子都删掉了,我想一条条的删除,应该怎么改呀?
我想在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)
);

那就改具体指向