Below is a list of built-in string/character functions that are available in Oracle Database.
Continue readingTag: functions
LAST_DAY() Function in Oracle
In Oracle Database, the LAST_DAY() function returns the last day of the month that contains the supplied date.
It accepts one argument, which is the date for which you want to find the last day of the month.
Continue readingROUND(date) Function in Oracle
In Oracle, the ROUND(date) function returns a date rounded to a specified date unit.
By default, it rounds the date to the nearest day, but you can provide an optional argument that specifies an alternative unit to use.
Oracle also has a ROUND(number) syntax, which is used on number. This article is solely about the ROUND(date) syntax, which is used on date.
COLLATION() Function in Oracle
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.