CodesJava

Easy learning with example program codes

how to create a function in plsql?


Pl sql function:

The pl sql function is a named PL/SQL block which performs one or more specific tasks and must returns a value.

create or replace function getMultiple(num1 in number, num2 in number)    
return number    
is     
  num3 number(8);    
begin    
  num3 :=num1*num2;    
  return num3;    
end;    
/

See more at: Plsql function.

Related topics



Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap