In Oracle Database, the NVL2() function allows us to replace null values with another value.
It’s similar to the NVL() function, except that it accepts three arguments instead of two. This allows us to specify a different value to return in the event the first argument is not null.
In Oracle Database, the NVL() function allows us to replace null values with another value.
MariaDB includes a bunch of date and time units that you can use when working with date and time values. For example, MONTH is a unit, and HOUR is another unit.
Some units are composite units. Composite units are when two units get combined into one. The naming convention is that each unit name is separated by an underscore. For example, MINUTE_SECOND is for minutes and seconds.
Below are some examples that demonstrate how composite units work in MariaDB.
Continue readingIn Oracle Database, the COALESCE() function returns the first non-null expression the expression list.
In Oracle Database, the ROWIDTONCHAR() function converts a ROWID value to NVARCHAR2 data type
It’s similar to the ROWIDTOCHAR() function, except that ROWIDTOCHAR() converts a ROWID value to VARCHAR2 data type.
In Oracle Database, the ROWIDTOCHAR() function converts a ROWID value to VARCHAR2 data type.
In Oracle Database, the CHARTOROWID() function converts a string value to ROWID data type.
In Oracle Database, the TO_DATE() function converts its argument to a value of DATE data type.
In Oracle Database, the RAWTONHEX() function converts a raw value to hexadecimal.
It’s similar to the RAWTOHEX() function, except that its value is always returned in the national character set.
In Oracle Database, the RAWTOHEX() function converts a raw value to hexadecimal.