rajnish123

 Profile Answers by rajnish123 Questions by rajnish123

• Dec 30th, 2006

 

hi,

suppose a function  add two number and you desire to call it from anonyms block.

create or replace function f_add(a in number,b in number) return number as

c number;

begin

c:= a+b;

return (c);

end;

to see output

sql> variable x number;

sql> begin

    :x := f_add(2,2);

   end;

sql> /

sql> print x

madhuk17

 Profile Answers by madhuk17 Questions by madhuk17

• Feb 8th, 2007

 

We can call a function from anonymous block as a part of sql statement written in that block.eg: create or replace function fn_emp(v_empno in number)return varchar2 isbeginselect ename into v_ename from empwhere empno=v_empno;return v_ename;end;this function we can use in sql statement like followsselect fn_emp(101) from emp;it can also be assigned to a variable like thisv_value:=fn_emp(101);