sql循环、游标、异常（国外英文资料）.docVIP

sql循环、游标、异常（国外英文资料） - if judgment declare V_b Boolean: = true; The begin If v_b then Dbms_output.put_line ( ok ); End the if; The end; - if the else declare V_b Boolean: = false; The begin If v_b then Dbms_output.put_line ( ok ); The else Dbms_output.put_line ( false ); End the if; The end; - if elsif else declare V_name varchar2 (20) : = sx; The begin If v_name = 0701 then Dbms_output. Put_line ( 0701 ); Elsif v_name = sx then Dbms_output. Put_line (v_name); - dbms_output.put_line ( v_name ); The else Dbms_output.put_line ( false ); End the if; The end; The loop loop, notice that exiting exit