清理数据库缓存

alter system flush shared_pool ;
alter system flush BUFFER_CACHE ;

 

 

create or replace procedure proc_test_cursor isuserRow newresult%rowtype;cursor userRows isselect * from newresult;beginfor userRow in userRows loopupdate sys_edu_content edu set edu.time=userRow.time where edu.id=userRow.id;end loop;end proc_test_cursor;