存储过程学习二

主要学习了

1.数据类型

2.变量定义

3.程序判断分支

4.循环

5.游标

6.块结构以及存储过程 代码结构

create or replace procedure pl_test_loop is
v_name mytest.name%type;
v_password mytest.password%type;
cursor cur_mytest is
select * from mytest;
begin
open cur_mytest;
loop
fetch cur_mytest into v_name,v_password;
exit when cur_mytest%notfound;
if v_name = 'zxgllhh' then
update mytest t set t.password = 'ttt' where t.name = v_name;
dbms_output.put_line('...name = '||v_name||', password = '||v_password);
end if;
end loop;
close cur_mytest;
commit;
end;
/

call pl_test_loop();

show error;

set serveroutput on;