const g_exp_bind_vars

g_exp_bind_vars constant varchar2(255):=':\w+'

const g_exp_hyperlinks

g_exp_hyperlinks constant varchar2(255):='<a href="[^"]+">[^<]+</a>'

const g_exp_ip_addresses

g_exp_ip_addresses constant varchar2(255):='(\d{1,3}\.){3}\d{1,3}'

const g_exp_email_addresses

g_exp_email_addresses constant varchar2(255):='^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$'

const g_exp_email_address_list

g_exp_email_address_list constant varchar2(255):='^((\s*[a-zA-Z0-9\._%-]+@[a-zA-Z0-9\.-]+\.[a-zA-Z]{2,4}\s*[,;:]){1,100}?)?(\s*[a-zA-Z0-9\._%-]+@[a-zA-Z0-9\.-]+\.[a-zA-Z]{2,4})*$'

const g_exp_double_words

g_exp_double_words constant varchar2(255):=' ([A-Za-z]+) \1'

const g_exp_cc_visa

g_exp_cc_visa constant varchar2(255):='^4[0-9]{12}(?:[0-9]{3})?$'

const g_exp_square_brackets

g_exp_square_brackets constant varchar2(255):='\[(.*?)\]'

const g_exp_curly_brackets

g_exp_curly_brackets constant varchar2(255):='{(.*?)}'

const g_exp_square_or_curly_brackets

g_exp_square_or_curly_brackets constant varchar2(255):='\[.*?\]|\{.*?\}'

function match

function match(
    p_str in clob,
    p_pattern in varchar2
) return t_str_array

return pattern matches as (pipelined) array