In Oracle Database, the HEXTORAW()
function converts hexadecimal to a raw value.
Author: Ian
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.
5 Functions to Extract the Week Number from a Date in MariaDB
Below are 5 functions that enable you to return the week number from a date in MariaDB. Four return just the week, and one returns both the week and year combined.
Continue readingCAST() 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_CURRENCY
specifies the string to use as the local currency symbol for theL
number format element.NLS_ISO_CURRENCY
determines what to use for theC
format element.NLS_DUAL_CURRENCY
specifies what to use for theU
format element.
Get the Current Login ID in SQL Server (T-SQL)
You can use the SUSER_ID()
function to return the login identification number of the current user.
You can also use it to return the login ID of another user.
This is similar to returning the current login name, except here we’re returning the ID instead.
Continue readingList 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 readingMariaDB RTRIM() vs RTRIM_ORACLE(): What’s the Difference?
MariaDB has an RTRIM()
function and a RTRIM_ORACLE()
function. Both functions do essentially the same thing. But there is a minor difference.
2 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 reading