主要学习了
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;