11.6 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 11-3 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;