In Oracle, the CEIL() function returns the smallest integer that is greater than or equal to its argument.
Category: DBMS
Database Management Systems
FLOOR() Function in Oracle
In Oracle, the FLOOR() function returns the largest integer equal to or less than its argument.
LOG() Function in Oracle
In Oracle, the LOG() function returns the logarithm, base n2, of n1, where n2 is the first argument and n1 is the second.
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 readingMongoDB $round vs $trunc: What’s the Difference?
MongoDB’s aggregation pipeline framework includes a $round operator and a $trunc operator. These operators perform similar, but different tasks.
ATAN2() 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 reading8 Functions to Return the Day from a Date in MariaDB
MariaDB has quite a number of functions that return the day from a date. It all depends on how you want to do it, and what you mean by “day”.
MariaDB needs to know whether you want the day name, the day of the week number, the day of the month, day of year, etc.
Below are 8 functions that enable you to return the day from a date in MariaDB, in its various forms.
Continue readingBITAND() Function in Oracle
In Oracle, the BITAND() function returns a bitwise AND of its two arguments.
SET NULL: Specify a String to Return Whenever a Null Value Occurs in SQLcl / SQL*Plus
SQLcl and SQL*Plus are command line interfaces for working with Oracle Database.
By default, they return an empty string whenever null occurs as a result of a SQL SELECT statement.
However, you can use SET NULL to specify a different string to be returned. Here I specified that the string null should be returned.