日志
游标简单使用
create or replace procedure v_exercise
is
v_userid varchar(20);
v_username varchar(20);
v_pwd varchar(20);
cursor tmp_user is select userid,username,pwd from userid;
begin
open tmp_user;
loop
fetch tmp_user into v_userid,v_username,v_pwd;
exit when tmp_user%notfound;
dbms_output.put_line(v_userid || ' ' || v_username);
end loop;
close tmp_user;
end v_exercise;
is
v_userid varchar(20);
v_username varchar(20);
v_pwd varchar(20);
cursor tmp_user is select userid,username,pwd from userid;
begin
open tmp_user;
loop
fetch tmp_user into v_userid,v_username,v_pwd;
exit when tmp_user%notfound;
dbms_output.put_line(v_userid || ' ' || v_username);
end loop;
close tmp_user;
end v_exercise;
点名卡
救生圈
时空机
热点灯
变色卡