select empno, job, sal
from emp

function CF_enameFormula return Char is
  retval varchar2(20);
begin
  select ename
    into retval
    from emp
    where empno = :empno;
  return (retval);
end;