Wednesday, 7 September 2011

IF FUNCTION

  Parameter
==""==""==
function CF_4Formula return Char is
V_NOTES VARCHAR2(1000);
begin
 IF :P_NOTES IS NOT NULL THEN
  V_NOTES := :P_NOTES;
 ELSE
  V_NOTES := NULL;
 END IF ;
 RETURN V_NOTES;
end;