In Oracle, the LOG()
function returns the logarithm, base n2
, of n1
, where n2
is the first argument and n1
is the second.
Tag: functions
LN() Function in Oracle
In Oracle, the LN()
function returns the natural logarithm of its argument, where the argument is greater than 0
.
In other words, it returns the base-e logarithm of its argument.
The number e, also known as Euler’s number, is a mathematical constant approximately equal to 2.71828.
Continue readingATAN2() Function in Oracle
In Oracle, the ATAN2()
function returns the arctangent (inverse tangent) of its two arguments.
ATAN() Function in Oracle
In Oracle, the ATAN()
function returns the arctangent (inverse tangent) of its argument.
In other words, it returns the value whose tangent is the argument.
Continue readingBITAND() Function in Oracle
In Oracle, the BITAND()
function returns a bitwise AND
of its two arguments.
ASIN() Function in Oracle
In Oracle, the ASIN()
function returns the arcsine (inverse sine) of its argument.
In other words, it returns the value whose sine is the argument.
Continue readingMariaDB JSON_VALID() Explained
In MariaDB, JSON_VALID()
is a built-in function that allows you to check whether or not a value is a valid JSON document.
You pass the value as an argument, and JSON_VALID()
returns 1
if it’s a valid JSON document, and 0
if not.
ACOS() Function in Oracle
In Oracle, the ACOS()
function returns the arccosine (inverse cosine) of its argument.
In other words, it returns the value whose cosine is the argument.
Continue readingABS() Function in Oracle
In Oracle, the ABS()
function returns the absolute value of its argument.
The absolute value is the non-negative value of a real number without regard to its sign. It describes the distance from zero that a number is on the number line, without considering direction.
Continue readingMariaDB JSON_UNQUOTE() Explained
In MariaDB, JSON_UNQUOTE()
is a built-in function that removes quotes from a JSON value. In other words, it “unquotes” a JSON value.