exceptionwithdivision.sql

来自「codding for pszone one can use it at pl」· SQL 代码 · 共 11 行

declare
a integer:=&a;
b integer:=&b;c number;
begin
c:=a/b;
dbms_output.put_line('division of a n b is '||c);
exception
when zero_divide then
dbms_output.put_line('a is divided by zero ');
end;
/