免费视频淫片aa毛片_日韩高清在线亚洲专区vr_日韩大片免费观看视频播放_亚洲欧美国产精品完整版

--ZERO_DIVIDE異常。使用系統(tǒng)預(yù)定義的異常處理，使用該處理后，程序運(yùn)行時(shí)系統(tǒng)就不會(huì)提示出現(xiàn)錯(cuò)誤。
 
declare
  v_number1 number(3):=10;
  v_number2 number(3):=0;
  v_number3 number(3);
  
  begin
     v_number3:=v_number1/v_number2;
     DBMS_OUTPUT.PUT_LINE(v_number3);
     EXCEPTION
        when ZERO_DIVIDE then
          DBMS_OUTPUT.PUT_LINE('除數(shù)不能為0');
  end;
輸出結(jié)果：DIVIDE ZERO

declare
  v_number1 number(3);
  v_char  char(5):='123c';
  begin
     v_number1:=to_number(v_char);  //將字符轉(zhuǎn)換成數(shù)字
     DBMS_OUTPUT.PUT_LINE('轉(zhuǎn)換成功');
     EXCEPTION
        when value_error then
          DBMS_OUTPUT.PUT_LINE('轉(zhuǎn)換沒(méi)成功');
  end;

declare
   v_name  school_students.stu_name%type;
   begin
      select stu_name into v_name
      from school_students
      where stu_id='2016322180021';
      dbms_output.put_line(v_name);
      EXCEPTION
        when  no_data_found then
           dbms_output.put_line('沒(méi)有數(shù)據(jù)');
        when  too_many_rows then
           dbms_output.put_line('數(shù)據(jù)太多');
        when  ZERO_DIVIDE then
           dbms_output.put_line('列出錯(cuò)列');
      
  end;

--用戶可以通過(guò)自定義異常來(lái)處理發(fā)生的錯(cuò)誤，語(yǔ)法格式為：
exception
   when 異常名 then
        語(yǔ)句塊 1；
    when  then
        語(yǔ)句塊2；
    [when others then
         語(yǔ)句塊3；]
end；

declare
   e_name  exception;
   v_num  number(8);
   begin
      select count(*) into v_num
      from school_students;
     if v_num>10 then
        RAISE  e_name;
     end if ;
     exception
       when e_name then
       dbms_output.put_line('最大值不能超過(guò)10');
    end;

declare
   v_name  school_students.stu_name%type;
   begin
      select stu_name into v_name
      from school_students
      where stu_id='2016322180021';
      dbms_output.put_line(v_name);
      EXCEPTION
        when  OTHERS then
           dbms_output.put_line('出錯(cuò)了');
  end;

declare
  n number(3):=-1;
  begin
     if n<0 then
         null;
     else
        DBMS_OUTPUT.PUT_LINE('正常');
     end if;
  end;