41.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 41-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