Checking NULL in PL/SQL
CREATE OR REPLACE FUNCTION date_null(
iv_number IN DATE,dt IN DATE)
RETURN integer
IS
d integer;
BEGIN
IF iv_number is NULL THEN d :=1;
ELSE
d :=2;
END IF ;
RETURN d;
END;
sharing some tech problems and soln
CREATE OR REPLACE FUNCTION date_null(
iv_number IN DATE,dt IN DATE)
RETURN integer
IS
d integer;
BEGIN
IF iv_number is NULL THEN d :=1;
ELSE
d :=2;
END IF ;
RETURN d;
END;
No comments:
Post a Comment