In Oracle Database, the COALESCE() function returns the first non-null expression the expression list.
Tag: functions
MariaDB FLOOR() vs TRUNCATE()
MariaDB has a FLOOR() function and a TRUNCATE() function that can return the same results or different results, depending on the exact value of their arguments.
Below is a quick rundown on the difference between FLOOR() and TRUNCATE() in MariaDB.
MariaDB ROUND() vs TRUNCATE()
MariaDB has a ROUND() function and a TRUNCATE() function that can return the same results or different results, depending on the exact value of their arguments.
As the function names suggest, ROUND() rounds the number and TRUNCATE() truncates the number. Truncating a number simply cuts it off without performing any rounding.
Below is a quick rundown on the difference between ROUND() and TRUNCATE() in MariaDB.
MariaDB ROUND() vs FLOOR()
MariaDB has a ROUND() function and a FLOOR() function that are similar in some ways, but quite different in other ways.
Below is a quick rundown on the difference between ROUND() and FLOOR() in MariaDB.
ROWIDTONCHAR() Function in Oracle
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.
ROWIDTOCHAR() Function in Oracle
In Oracle Database, the ROWIDTOCHAR() function converts a ROWID value to VARCHAR2 data type.
CHARTOROWID() Function in Oracle
In Oracle Database, the CHARTOROWID() function converts a string value to ROWID data type.
TO_DATE() Function in Oracle
In Oracle Database, the TO_DATE() function converts its argument to a value of DATE data type.
RAWTONHEX() Function in Oracle
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.
RAWTOHEX() Function in Oracle
In Oracle Database, the RAWTOHEX() function converts a raw value to hexadecimal.