In Oracle Database, the COLLATION() function returns the name of the derived collation for its argument.
NLS_CHARSET_NAME() Function in Oracle
In Oracle Database, the NLS_CHARSET_NAME() function returns the character set name of a given character set, based on its ID. You pass the character set ID as an argument, and the function returns its name.
NLS_COLLATION_NAME() Function in Oracle
In Oracle Database, the NLS_COLLATION_NAME() function returns the name of a given collation, based on its ID. You pass the collation ID when calling the function, and it returns the collation name.
NLS_COLLATION_ID() Function in Oracle
In Oracle Database, the NLS_COLLATION_ID() function returns the ID of a given collation. You pass the collation name when calling the function, and it returns the collation ID.
NLS_CHARSET_DECL_LEN() Function in Oracle
In Oracle, the NLS_CHARSET_DECL_LEN() function returns the declaration length (in number of characters) of an NCHAR column.
NLS_CHARSET_ID() Function in Oracle
In Oracle, the NLS_CHARSET_ID() function returns the character set ID number of a given character set. You pass the character set name as an argument, and it returns its ID.
MariaDB JSON_VALUE() vs JSON_QUERY(): What’s the Difference?
In MariaDB, the JSON_VALUE() function and JSON_QUERY() function do similar things – they return data from a JSON document.
So what’s the difference?
The main difference is that JSON_VALUE() returns scalar values, whereas JSON_QUERY() returns arrays and objects.
FROM_TZ() Function in Oracle
In Oracle Database, the FROM_TZ() function converts a timestamp value and a time zone to a TIMESTAMP WITH TIME ZONE value.
You pass the timestamp value and the time zone as two separate arguments, and the function returns them as a TIMESTAMP WITH TIME ZONE value.
How to Return a List of Valid Time Zones in Oracle Database
Sometimes we need to specify a time zone when using datetime functions in Oracle.
But there are a lot of time zones out there. How do we remember them all? And how do we know our system supports a given time zone?
Fortunately, we can query the V$TIMEZONE_NAMES view to return a list of valid time zones.
SESSIONTIMEZONE Function in Oracle
In Oracle Database, the SESSIONTIMEZONE function returns the time zone of the current session.