Package Overloading
Tipp 48
Thema: PACKAGES
Datenbank-Version: RDBMS 8.x
Erstellt am 07.10.19
Bearbeitet am 07.10.19
CREATE OR REPLACE PACKAGE overload IS
FUNCTION double (var1 number) RETURN NUMBER;
--pragma restrict_references (double, WNDS,WNPS,RNPS,RNDS);
FUNCTION double (var1 varchar2) RETURN VARCHAR2;
--pragma restrict_references (double, WNDS,WNPS,RNPS,RNDS);
END;
/
CREATE OR REPLACE PACKAGE BODY overload IS
FUNCTION double (var1 NUMBER) RETURN NUMBER
IS
BEGIN
RETURN var1*2;
END;
FUNCTION double (var1 VARCHAR2) RETURN VARCHAR2
IS
BEGIN
RETURN var1||'-'||var1;
END;
END;
/