Passing table as variable in function

Passing table as variable in function

--Dynamic function table name as variable
CREATE OR REPLACE FUNCTION f_sys_id (p_table IN VARCHAR2)
   RETURN VARCHAR2
IS
   sql_stmt   VARCHAR2 (100);
   RESULT     VARCHAR2 (20);
BEGIN
   sql_stmt :=
         'SELECT '
      || TO_CHAR (SYSDATE, 'RRRRMMDDHH24MISS')
      || '||'
      || 'lpad(COUNT(*)+1,6,0) from '
      || p_table
      || ' where sys_id = '
      || TO_CHAR (SYSDATE, 'RRRRMMDDHH24MISS');

   EXECUTE IMMEDIATE sql_stmt
                INTO RESULT;

   RETURN RESULT;
END;
/