declare
cursor c_jobs is select job from user_jobs;
r_job c_jobs%rowtype;
begin
open c_jobs;
loop
fetch c_jobs into r_job;
exit when c_jobs%notfound;
dbms_job.remove(r_job.job);
end loop;
end ;
cursor c_jobs is select job from user_jobs;
r_job c_jobs%rowtype;
begin
open c_jobs;
loop
fetch c_jobs into r_job;
exit when c_jobs%notfound;
dbms_job.remove(r_job.job);
end loop;
end ;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货