Database Management Systems
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 readingBelow 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 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.
Continue readingIn 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.
Continue readingHere are six ways to check what version of MariaDB you’re currently running.
Continue readingWhen 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.
Continue readingMariaDB provides a WEEKDAY() function and a DAYOFWEEK() function, both of which return the day of the week, represented as a number.
But the number returned is different between these functions.
This post looks at the difference.
Continue reading