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 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 reading6 Ways to Check your MariaDB Version
Here are six ways to check what version of MariaDB you’re currently running.
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.
List of Languages Supported by Oracle Database
The following table contains a list of territories that are supported by Oracle Database.
Continue readingWEEKDAY() 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.
Continue readingHow 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.
Continue readingFix: “the leading precision of the interval is too small” in Oracle Database
If you’re trying to use an interval literal in Oracle, but you keep getting the “leading precision of the interval is too small” error, hopefully this helps.
Continue reading