Saturday, January 24, 2015

Parametrized Function example in PL/SQL

CREATE OR REPLACE FUNCTION vma_find_area (l   IN NUMBER,
                                          w   IN NUMBER DEFAULT 30)
   RETURN NUMBER
AS
   a   NUMBER;
BEGIN
   a := w * l;
   RETURN a;
END;

-- Different ways to call--
DECLARE
   a   NUMBER := 0;
BEGIN
   a := vma_find_area (10, 10);              --Positional notations/parameters
   DBMS_OUTPUT.put_line ('The product is ...' || a);

   a := vma_find_area (w => 20, l => 10); --named notations/parameters here order is not imp
   DBMS_OUTPUT.put_line ('The product is ...' || a);

   a := vma_find_area (20, w => 20); --Mixed notations/parameters here order is important first positional and then Named.
   DBMS_OUTPUT.put_line ('The product is ...' || a);

   a := vma_find_area (l => 10);                --Default notations/parameters
   DBMS_OUTPUT.put_line ('The product is ...' || a);
END;

/

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect