begin
? for x in (select object_name from user_objects where object_name like 'CDD_%')?? loop
???
???? execute immediate 'delete from '||x.object_name;
? end loop;
end;

轉載于:https://www.cnblogs.com/dazhaxie/archive/2012/11/28/oracle.html

總結

以上是生活随笔為你收集整理的oracle for循环的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。