
 CREATE OR REPLACE FUNCTION FUNC1 (X IN VARCHAR2)
 RETURN NUMBER IS
 V_SAL NUMBER(9,2);
 BEGIN
 SELECT SAL INTO V_SAL FROM EMP WHERE ENAME = 'WARD';
 RETURN(V_SAL);
 END;

 SELECT FUNC1('RAJ') FROM DUAL;