43.9 GET_DOMAIN Function

This function extracts a domain from a link or email.

Syntax

FUNCTION GET_DOMAIN (
    p_string IN VARCHAR2 )
    RETURN VARCHAR2;

Parameters

Table 43-6 GET_DOMAIN Function Parameters

Parameter	Description
p_string	The input string.

Returns

This function returns a domain from a url or email.

Example

select apex_string_util.get_domain('https://apex.oracle.com/en/platform/low-code/') from dual
-> apex.oracle.com