ORACLE PL SQL基础.pptVIP

* * * * * * 示例一 declare v_num1 px_1.v_num%type; begin v_num1 := no ; case v_num when 1 then update px_2 set v_char=a where v_num = v_num1; when 2 then update px_2 set v_char=b where v_num = v_num1; else dbms_output.put_line(ERROR) ; end case ; end ; 示例二 declare vn_num px_1.v_num%type; vn_char px_1.v_char%type; begin select v_num,v_char into vn_num,vn_char from px_1 where v_num = no ; case when vn_num 3 then update px_2 set v_char=a where v_num = vn_num; when vn_num 6 then update px_2 set v_char=b where v_num = vn_num; else db