22.7 GET_FILE_TYPE Function

This function returns a file type, based on a file name extension.

Syntax

APEX_DATA_PARSER.GET_FILE_TYPE (
    p_file_name IN VARCHAR2 )
RETURN t_file_type;

Parameter

Parameter Description
p_file_name File name to get the file type.

Returns

Returns the file type as t_file_type.

Example

DECLARE 
   l_file_type apex_data_parser.t_file_type;
BEGIN
    l_file_type := apex_data_parser.get_file_type( 'test.xlsx' );
END;