GET_SLUG Function

56.11 GET_SLUG Function

Use this function to convert the input string to a "-" separated string, with special characters removed. The returned string contains a maximum of 255 characters in total, including hash (if requested).

Syntax

APEX_STRING_UTIL.GET_SLUG (
    p_string               IN VARCHAR2,
    p_hash_length          IN PLS_INTEGER DEFAULT 0 )
RETURN VARCHAR2;

Parameters

Parameter	Description
`p_string`	The input string.
`p_hash_length`	If > 0 (default is `0`), append random digits to make the result unique. The longest hash that may be returned is 38 digits.

Example

select apex_string_util.get_slug('hey now, brown cow! 1') from dual; 
-> hey-now-brown-cow-1
--
select apex_string_util.get_slug('hey now, brown cow! 1',4) from dual;
-> hey-now-brown-cow-1-3486

Parent topic: APEX_STRING_UTIL