PL/SQL Parametrized Function example

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