Skip to main content

​
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