RosettaCodeData/Task/Detect-division-by-zero/PL-SQL/detect-division-by-zero-1.sql
Ingy döt Net d066446780 langs a-z
2013-04-10 22:43:41 -07:00

11 lines
185 B
SQL

FUNCTION divide(n1 IN NUMBER, n2 IN NUMBER)
RETURN BOOLEAN
IS
result NUMBER;
BEGIN
result := n1/n2;
RETURN(FALSE);
EXCEPTION
WHEN ZERO_DIVIDE THEN
RETURN(true);
end divide;