Function support: oracle

Function Category Kind Status Rendering
< comparison scalar standard left < right
<= comparison scalar standard left <= right
= comparison scalar standard left = right
> comparison scalar standard left > right
>= comparison scalar standard left >= right
AND logical scalar standard left AND right
BETWEEN comparison scalar standard value BETWEEN low AND high
IN comparison scalar standard value IN (items)
ISNULL comparison scalar standard value IS NULL
LIKE comparison scalar standard string LIKE pattern
NOT logical scalar standard NOT operand
OR logical scalar standard left OR right
abs math scalar standard abs(value)
add arithmetic scalar standard add(…) — dialect-specific rendering
ascii string scalar standard ascii(character)
at_zone other scalar standard at_zone(…) — dialect-specific rendering
avg aggregate aggregate standard avg(value)
bit_length string scalar standard bit_length(string)
btrim string scalar standard btrim(string, characters)
calendar_distance datetime scalar standard calendar_distance(…) — dialect-specific rendering
case conditional scalar standard case(…) — dialect-specific rendering
ceil math scalar standard ceil(value)
ceiling math scalar standard ceiling(value)
char_length string scalar standard char_length(string)
character_length string scalar standard character_length(string)
chr string scalar standard chr(code)
clock_now datetime scalar standard CURRENT_TIMESTAMP
coalesce conditional scalar standard coalesce(…) — dialect-specific rendering
concat string scalar standard concat(value)
concat_ws string scalar standard concat_ws(separator)
count aggregate aggregate standard count(value)
date datetime scalar standard date(value)
date_trunc datetime scalar standard date_trunc(part, value)
day datetime scalar overridden EXTRACT(DAY FROM value)
day_add datetime scalar standard (value + INTERVAL (n) DAY)
day_begin datetime scalar standard date_trunc('day', value)
days_between datetime scalar overridden TRUNC(CAST(end AS DATE) - CAST(start AS DATE))
divide arithmetic scalar standard divide(…) — dialect-specific rendering
floor math scalar standard floor(value)
hour datetime scalar overridden EXTRACT(HOUR FROM value)
initcap string scalar standard initcap(string)
instr other scalar native instr(…)
left string scalar standard left(string, n)
length string scalar standard length(string)
listagg other aggregate native listagg(…)
lower string scalar standard lower(string)
lpad string scalar standard lpad(string, length, fill)
ltrim string scalar standard ltrim(string, characters)
make_date datetime scalar standard make_date(year, month, day)
make_time datetime scalar standard make_time(hour, minute, second)
make_timestamp datetime scalar standard make_timestamp(year, month, day, hour, minute, second)
max aggregate aggregate standard max(value)
md5 string scalar standard md5(string)
min aggregate aggregate standard min(value)
minus arithmetic scalar standard minus(…) — dialect-specific rendering
minute datetime scalar overridden EXTRACT(MINUTE FROM value)
mod math scalar standard mod(dividend, divisor)
month datetime scalar overridden EXTRACT(MONTH FROM value)
month_add datetime scalar standard (value + INTERVAL (n) MONTH)
month_begin datetime scalar standard date_trunc('month', value)
month_end datetime scalar overridden TRUNC(LAST_DAY(value))
months_between datetime scalar overridden TRUNC(MONTHS_BETWEEN(end, start))
multiply arithmetic scalar standard multiply(…) — dialect-specific rendering
negate arithmetic scalar standard negate(…) — dialect-specific rendering
now datetime scalar standard CURRENT_TIMESTAMP
octet_length string scalar standard octet_length(string)
overlay string scalar standard overlay(string, replacement, start, length)
parse_date datetime scalar native TO_DATE(value, format)
parse_time datetime scalar native TO_DATE(value, format)
parse_timestamp datetime scalar native TO_TIMESTAMP(value, format)
pi math scalar standard pi()
position string scalar standard POSITION(substr IN str)
power math scalar standard power(base, exponent)
quarter_begin datetime scalar standard date_trunc('quarter', value)
quarter_end datetime scalar overridden LAST_DAY(ADD_MONTHS(TRUNC(value, 'Q'), 2))
random math scalar standard random()
regexp_count pattern_matching scalar standard regexp_count(string, pattern, start)
regexp_like pattern_matching scalar standard regexp_like(string, pattern, flags)
regexp_replace pattern_matching scalar standard regexp_replace(string, pattern, replacement, flags)
regexp_substr pattern_matching scalar standard regexp_substr(string, pattern)
repeat string scalar standard repeat(string, number)
replace string scalar standard replace(string, from, to)
reverse string scalar standard reverse(string)
right string scalar standard right(string, n)
round math scalar standard round(value, scale)
rpad string scalar standard rpad(string, length, fill)
rtrim string scalar standard rtrim(string, characters)
second datetime scalar overridden EXTRACT(SECOND FROM value)
split_part string scalar standard split_part(string, delimiter, n)
sqrt math scalar standard sqrt(value)
starts_with string scalar standard starts_with(string, prefix)
string_agg aggregate aggregate standard string_agg(value, separator)
strpos string scalar standard strpos(string, substring)
substr string scalar standard substr(string, start, length)
substring string scalar standard substring(string, start, length)
sum aggregate aggregate standard sum(value)
time datetime scalar standard time(value)
timestamp datetime scalar standard timestamp(value)
to_bigint conversion scalar standard CAST(value AS BIGINT)
to_boolean conversion scalar standard CAST(value AS BOOLEAN)
to_char formatting scalar standard to_char(value, format)
to_date other scalar overridden to_date(…) — dialect-specific rendering
to_decimal conversion scalar standard CAST(value AS DECIMAL(precision, scale))
to_double conversion scalar standard CAST(value AS DOUBLE)
to_float conversion scalar standard CAST(value AS FLOAT)
to_hex string scalar standard to_hex(number)
to_integer conversion scalar standard CAST(value AS INTEGER)
to_interval other scalar native to_interval(…) — dialect-specific rendering
to_number formatting scalar standard to_number(value, format)
to_smallint conversion scalar standard CAST(value AS SMALLINT)
to_text conversion scalar overridden CAST(value AS VARCHAR(4000))
CAST(value AS VARCHAR(4000))
CAST(value AS VARCHAR(4000))
CAST(value AS VARCHAR(4000))
CAST(value AS VARCHAR(4000))
CAST(value AS VARCHAR(4000))
CAST(value AS VARCHAR(4000))
CAST(value AS VARCHAR(4000))
CAST(value AS VARCHAR(4000))
CAST(value AS VARCHAR(4000))
CAST(value AS VARCHAR(4000))
CAST(value AS VARCHAR(4000))
to_time other scalar overridden to_time(…) — dialect-specific rendering
to_timestamp other scalar overridden CAST(value AS TIMESTAMP)
TO_TIMESTAMP(value, format)
FROM_TZ(TO_TIMESTAMP(value, format), 'UTC') AT TIME ZONE tz
`TO_TIMESTAMP(year
to_utc other scalar standard to_utc(…) — dialect-specific rendering
to_varchar conversion scalar standard CAST(value AS VARCHAR(length))
today datetime scalar standard CURRENT_DATE
translate string scalar standard translate(string, from, to)
trim string scalar standard trim(string, characters)
upper string scalar standard upper(string)
year datetime scalar overridden EXTRACT(YEAR FROM value)
year_add datetime scalar standard (value + INTERVAL (n) YEAR)
year_begin datetime scalar standard date_trunc('year', value)
year_end datetime scalar overridden LAST_DAY(ADD_MONTHS(TRUNC(value, 'YYYY'), 11))
years_between datetime scalar standard CAST(EXTRACT(YEAR FROM age(end, start)) AS INTEGER)