20.7 GET_FILE_TYPE Function

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

Syntax

FUNCTION GET_FILE_TYPE(
    p_file_name IN VARCHAR2 ) RETURN t_file_type;

Parameter

Table 20-4 GET_FILE_TYPE Parameters

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;