Oracle 游标范例

create or replace procedure sp_CurTest
is
cursor cur is select * from tUserinfo ;
begin
for user in cur
    loop
    insert into job_test(id,jobcontent,jobtime) values(user.Dept_ID,user.Username,sysdate);  
    end loop;
end;