Oracle PL/SQL Einzel-Tipp ansehen

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;
/