41.10 GET_FILE_EXTENSION Function

This function returns a file name's extension.

Syntax

FUNCTION GET_FILE_EXTENSION ( 
    p_filename      IN VARCHAR2 )
    RETURN VARCHAR2;

Parameters

Table 41-7 GET_FILE_EXTENSION Function Parameters

Parameter	Description
p_filename	The filename.

Returns

This function returns the file name's extension in lower case.

Example

The following example shows how to use the GET_FILE_EXTENSION function.

select apex_string_util.get_file_extension('foo.pPtx') from dual
-> pptx
select apex_string_util.get_file_extension('PLEASE.READ.ME.TXT') from dual
-> txt