PL SQL Program For TO RETRIEVE THE NAME OF THE EMPLOYEE.

PL SQL Program For TO RETRIEVE THE NAME OF THE EMPLOYEE. 


CREATE OR REPLACE FUNCTION RETURN_NAME(NO NUMBER) RETURN VARCHAR2 IS
NAM VARCHAR2(25);
BEGIN
SELECT NAME INTO NAM FROM EMPLOYEE WHERE EMPNO=NO;
RETURN NAM;
END;