存储过程学习二

主要学习了

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;