# Oracle AI Database 26: SQL Language Reference function pages
# generated by tools/gen_function_catalogs.py on 2026-10-04; one lower-case name per line
abs
acos
add_months
any_value
approx_count
approx_count_distinct
approx_count_distinct_agg
approx_count_distinct_detail
approx_median
approx_percentile
approx_percentile_agg
approx_percentile_detail
approx_rank
approx_sum
ascii
asciistr
asin
atan
atan2
avg
bfilename
bin_to_num
bit_and_agg
bit_or_agg
bit_xor_agg
bitand
boolean_and_agg
boolean_or_agg
calendar_add_x_periods
calendar_since
calendar_start_end
calendar_x_of_y
cardinality
cast
ceil
chartorowid
checksum
chr
cluster_details
cluster_distance
cluster_id
cluster_probability
cluster_set
coalesce
collation
collect
compose
con_dbid_to_id
con_guid_to_id
con_name_to_id
con_uid_to_id
concat
convert
corr
corr_k
corr_s
cos
cosh
cosine_distance
count
covar_pop
covar_samp
cube_table
cume_dist
current_date
current_timestamp
cv
dataobj_to_mat_partition
dataobj_to_partition
dbtimezone
decode
decompose
dense_rank
depth
deref
domain_check
domain_check_type
domain_display
domain_name
domain_order
dump
empty_blob
every
existsnode
exp
extract
extractvalue
feature_compare
feature_details
feature_id
feature_set
feature_value
first
first_value
fiscal_add_x_periods
fiscal_start_end
fiscal_x_of_y
floor
from_tz
from_vector
greatest
group_id
grouping
grouping_id
hextoraw
initcap
inner_product
instr
instr2
instr4
instrb
instrc
is_uuid
iteration_number
json_array
json_arrayagg
json_dataguide
json_equal
json_exists
json_object
json_objectagg
json_query
json_scalar
json_serialize
json_table
json_transform
json_value
kurtosis_pop
kurtosis_samp
l1_distance
l2_distance
lag
last
last_day
last_value
lead
least
length
length2
length4
lengthb
lengthc
listagg
ln
lnnvl
localtimestamp
log
lower
lpad
ltrim
make_ref
max
median
min
mod
months_between
nanvl
nchr
new_time
next_day
nls_charset_decl_len
nls_charset_id
nls_charset_name
nls_collation_id
nls_collation_name
nls_initcap
nls_lower
nls_upper
nlssort
nth_value
ntile
nullif
numtodsinterval
numtoyminterval
nvl
nvl2
ora_dm_partition_name
ora_dst_affected
ora_dst_convert
ora_dst_error
ora_hash
ora_invoking_user
ora_invoking_userid
path
percent_rank
percentile_cont
percentile_disc
power
powermultiset
powermultiset_by_cardinality
prediction
prediction_bounds
prediction_cost
prediction_details
prediction_probability
prediction_set
presentnnv
presentv
previous
rank
ratio_to_report
raw_to_uuid
rawtohex
rawtonhex
ref
reftohex
regexp_count
regexp_instr
regexp_like
regexp_replace
regexp_substr
regr_avgx
regr_avgy
regr_count
regr_intercept
regr_r2
regr_slope
regr_sxx
regr_sxy
regr_syy
remainder
replace
retail_add_x_periods
retail_day_exists
retail_start_end
retail_x_of_y
round
row_number
rowidtochar
rowidtonchar
rpad
rtrim
scn_to_timestamp
sessiontimezone
sign
sin
sinh
skewness_pop
skewness_samp
soundex
sqrt
standard_hash
stats_binomial_test
stats_crosstab
stats_f_test
stats_ks_test
stats_mode
stats_mw_test
stats_one_way_anova
stats_t_test_indep
stats_t_test_indepu
stats_t_test_one
stats_t_test_paired
stats_wsr_test
stddev
stddev_pop
stddev_samp
substr
substr2
substr4
substrb
substrc
sum
sys_connect_by_path
sys_context
sys_dburigen
sys_extract_utc
sys_guid
sys_op_zone_id
sys_typeid
sys_xmlagg
sys_xmlgen
sysdate
systimestamp
tan
tanh
timestamp_to_scn
to_binary_double
to_binary_float
to_blob
to_char
to_clob
to_date
to_dsinterval
to_lob
to_multi_byte
to_nchar
to_nclob
to_number
to_single_byte
to_timestamp
to_timestamp_tz
to_utc_timestamp_tz
to_vector
to_yminterval
translate
treat
trim
trunc
tz_offset
uid
unistr
upper
user
userenv
uuid
uuid_to_raw
validate_conversion
value
var_pop
var_samp
variance
vector
vector_chunks
vector_dimension_count
vector_dimension_format
vector_dims
vector_distance
vector_embedding
vector_norm
vector_serialize
vsize
width_bucket
xmlagg
xmlcast
xmlcdata
xmlcolattval
xmlcomment
xmlconcat
xmldiff
xmlelement
xmlexists
xmlforest
xmlisvalid
xmlparse
xmlpatch
xmlpi
xmlquery
xmlsequence
xmlserialize
xmltable
xmltransform
