Below is a full list of NLS parameters in Oracle Database, along with their default values, and scopes that each parameter is available in.
Ian
MariaDB 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.
TO_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.
6 Ways to Check your MariaDB Version
Here are six ways to check what version of MariaDB you’re currently running.
Find 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.
List of Languages Supported by Oracle Database
The following table contains a list of territories that are supported by Oracle Database.
WEEKDAY() vs DAYOFWEEK() in MariaDB: What’s the Difference?
MariaDB 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.
How to Install Oracle Database on Windows
Below are the steps I used to install Oracle Database 18c XE on Windows 10.
Oracle Database 18c XE is the free Express Edition of Oracle. This is a good entry point into Oracle Database. XE is a regular Oracle Database, and it therefore provides compatibility with other Oracle Database editions. You can always move to another edition if you ever need to.