Search notes:

Oracle SQL functions

Some functions related to null
Related to the DATE data type.
Related to the INTERVAL data type
Related to the TIMESTAMP data type
Related to text: text.
Some functions that are related to LOBs
Functions for the raw datatype
Functions that are useful in a container database (CDB)
ora_hash
functions for regular expressions
sys_context
Globalization (NLS) related functions.
sys_guid returns a Globally Unique Identifier (aka GUID or UUID).
Conversion functions:
math functions
userenv
JSON related functions such as json_table.
Domain related functions: domain_display, domain_order, domain_name and domain_check
XML related functions
regr_* functions
Binary functions such as
Functions related to the SCN:
dump

ORA_DATABASE_NAME

ora_database_name is a synonym for dbms_standard.database_name and possibly evaluates to the same value as sys_context('userenv', 'db_name').

See also

v$sqlfn_metadata is a (queryable) view that lists Oracle functions.
sys_op_* functions.

Index