Database Management Systems
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 the L number format element. NLS_ISO_CURRENCY determines what to use for the C format element.NLS_DUAL_CURRENCY specifies what to use for the U format element.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.
Below is a full list of NLS parameters in Oracle Database, along with their default values, and scopes that each parameter is available in.
MariaDB has an RTRIM() function and a RTRIM_ORACLE() function. Both functions do essentially the same thing. But there is a minor difference.
Below are two functions that can be used to extract the month from a date in Oracle Database.
In Oracle Database, the TO_CHAR(number) function converts a number to a VARCHAR2 value in the format specified by the format argument.
Below is a full list of the format elements that can be used to format numbers in Oracle Database.
Here are six ways to check what version of MariaDB you’re currently running.
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.
The following table contains a list of territories that are supported by Oracle Database.