In Oracle Database, the HEXTORAW() function converts hexadecimal to a raw value.
Category: Oracle
DECOMPOSE() Function in Oracle
In Oracle Database, the DECOMPOSE() function returns the result of applying one of the Unicode decompositions to its string argument. The decomposition is determined by the second (optional) argument.
It’s the opposite of the COMPOSE() function.
COMPOSE() Function in Oracle
In Oracle Database, the COMPOSE() function returns the result of applying the Unicode canonical composition, as described in the Unicode Standard definition D117, to its string argument.
It’s the opposite of the DECOMPOSE() function.
CAST() Function in Oracle
In Oracle Database, the CAST() function converts its argument to a different data type.
More specifically, it lets you convert built-in data types or collection-typed values of one type into another built-in data type or collection type.
Continue readingHow to Change your Session’s Currency Symbol in Oracle
In Oracle Database, there are a few different NLS parameters that determine how currency is displayed when using functions like TO_CHAR() to format a number as a currency.
NLS_CURRENCYspecifies the string to use as the local currency symbol for theLnumber format element.NLS_ISO_CURRENCYdetermines what to use for theCformat element.NLS_DUAL_CURRENCYspecifies what to use for theUformat element.
List of NLS Parameters in Oracle Database
Below is a full list of NLS parameters in Oracle Database, along with their default values, and scopes that each parameter is available in.
Continue reading2 Functions that Return the Month from a Date in Oracle
Below are two functions that can be used to extract the month from a date in Oracle Database.
Continue readingTO_CHAR(number) Function in Oracle
In Oracle Database, the TO_CHAR(number) function converts a number to a VARCHAR2 value in the format specified by the format argument.
List of Number Format Elements in Oracle
Below is a full list of the format elements that can be used to format numbers in Oracle Database.
Continue readingFind Out Which Quarter a Date Belongs to in Oracle
When using the TO_CHAR(datetime) function in Oracle Database, you can use the Q format element to return the quarter that a given date belongs to.