In Oracle Database, the MONTHS_BETWEEN()
function returns the number of months between two dates.
Category: DBMS
Database Management Systems
4 Ways to Change the Time Zone in Oracle
In Oracle Database, time zones can be set in various places. Below are four ways to change the time zone when using Oracle.
Continue readingOracle String Functions (Full List)
Below is a list of built-in string/character functions that are available in Oracle Database.
Continue readingLAST_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.