get file suffix from path

CREATE OR REPLACE FUNCTION get_file_suffix (p_file IN VARCHAR2) RETURN varchar2 IS v_file_suffix VARCHAR2(5); BEGIN BEGIN /* || This Function returns a varchar2 string of the file suffix – any suffix length is returned, || If no suffix exists then NULL