how ı can select fırst_name from employees table with function?

INPUT:FIRST_NAME
OUTPUT: (RETURN) EMPLOYEE_ID

CREATE OR REPLACE FUNCTION GET_EMPLOYEE_ID
(
  FIV_fırst_name IN employees .fırst_name%TYPE 
) RETURN VARCHAR AS 
VS_fırst_name employees .fırst_name%TYPE;
  VS_RETURN VARCHAR2(20);

BEGIN
-------------??????------
END;


Source: oracle

Leave a Reply