Jirange

 Profile Answers by Jirange 

• Nov 7th, 2008

 

eg,
create or replace fun_1 return varchar2
as
ddmmyy varchar2;
begin
select sysdate into ddmmyy from dual;
end fun1;

in above example function fun_1 calling another function (i.e. sysdate) thro' select statement.
 this way you can call any function in pl/sql function