In Oracle Database, the UID function returns an integer that uniquely identifies the session user (the user who logged on).
functions
USER Function in Oracle
In Oracle Database, the USER function returns the name of the session user (the user who logged on).
SYS_GUID() Function in Oracle
In Oracle Database, the SYS_GUID() function generates and returns a globally unique identifier (RAW value) made up of 16 bytes.
On most platforms, the generated identifier consists of a host identifier, a process or thread identifier of the process or thread invoking the function, and a nonrepeating value (sequence of bytes) for that process or thread.
NULLIF() Function in Oracle
In Oracle Database, the NULLIF() function compares two expressions, and returns null if both expressions are equal. If they are not equal, then the function returns the first expression.
NVL() Function in Oracle
In Oracle Database, the NVL() function allows us to replace null values with another value.
COALESCE() Function in Oracle
In Oracle Database, the COALESCE() function returns the first non-null expression the expression list.
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.