
 CREATE OR REPLACE FUNCTION FUNC1 (X IN VARCHAR2)
 RETURN VARCHAR2 IS
 V_NAME VARCHAR2(10);
 BEGIN
 SELECT ENAME INTO V_NAME FROM EMP WHERE EMPNO = 7369;
 RETURN (V_NAME);
 END;

SELECT FUNC1('GOWD') FROM DUAL;