declare
num int:=&number;
begin
if(num mod 5=0) then
dbms_output.put_line('no. is divisible by 5');
else
dbms_output.put_line('no. is not divisible by 5');
end if;
end;
----------Alternative-----------------
declare
num int:=&number;
result int;
begin
SELECT decode(num MOD 5, 0, 'divisible', 'nod devisible') INTO RESULT
FROM dual;
dbms_output.put_line(RESULT);
end;
Comments
Post a Comment