String Functions

regexp_count

returns number of matches of regular expression pattern in subject Supported Signatures

function regexp_count(varchar, varchar) returns decimal(38, 0)
function regexp_count(varchar, varchar, decimal(38, 0)) returns decimal(38, 0)
function regexp_count(varchar, varchar, decimal(38, 0), varchar) returns decimal(38, 0)

🔗 Official Documentation

regexp_instr

returns position at which the subject matches the regular expression pattern Supported Signatures

function regexp_instr(varchar, varchar) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0)) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0), decimal(38, 0), decimal(38, 0), varchar) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0), decimal(38, 0), decimal(38, 0), varchar, decimal(38, 0)) returns decimal(38, 0)

🔗 Official Documentation

regexp_like

returns TRUE if subject RLIKE pattern Supported Signatures

function regexp_like(varchar, varchar) returns boolean
function regexp_like(varchar, varchar, varchar) returns boolean

🔗 Official Documentation

regexp_replace

replaces substring in subject matching a regular expression pattern Supported Signatures

function regexp_replace(varchar, varchar) returns varchar
function regexp_replace(varchar, varchar, varchar) returns varchar
function regexp_replace(varchar, varchar, varchar, decimal(38, 0)) returns varchar
function regexp_replace(varchar, varchar, varchar, decimal(38, 0), decimal(38, 0)) returns varchar
function regexp_replace(varchar, varchar, varchar, decimal(38, 0), decimal(38, 0), varchar) returns varchar

🔗 Official Documentation

regexp_substr

returns substring in subject which matches the regular expression pattern Supported Signatures

function regexp_substr(varchar, varchar) returns varchar
function regexp_substr(varchar, varchar, decimal(38, 0)) returns varchar
function regexp_substr(varchar, varchar, decimal(38, 0), decimal(38, 0)) returns varchar
function regexp_substr(varchar, varchar, decimal(38, 0), decimal(38, 0), varchar) returns varchar
function regexp_substr(varchar, varchar, decimal(38, 0), decimal(38, 0), varchar, decimal(38, 0)) returns varchar

🔗 Official Documentation

regexp_substr_all

returns all substring in subject which matches the regular expression pattern Supported Signatures

function regexp_substr_all(varchar, varchar) returns array
function regexp_substr_all(varchar, varchar, decimal(38, 0)) returns array
function regexp_substr_all(varchar, varchar, decimal(38, 0), decimal(38, 0)) returns array
function regexp_substr_all(varchar, varchar, decimal(38, 0), decimal(38, 0), varchar) returns array
function regexp_substr_all(varchar, varchar, decimal(38, 0), decimal(38, 0), varchar, decimal(38, 0)) returns array

🔗 Official Documentation