In Oracle, the TANH() function returns the hyperbolic tangent of its argument.
Category: DBMS
Database Management Systems
TAN() Function in Oracle
In Oracle, the TAN() function returns the tangent of its argument, where the argument is an angle expressed in radians.
3 Ways to Return a Random Sample of Documents from a MongoDB Collection
If you need to return a small sample of random documents from a collection, here are three approaches you can try using the aggregation pipeline.
Continue readingNANVL() Function in Oracle
In Oracle, the NANVL() function allows us to deal with NaN values by specifying another number to return in its place.
The way it works is, it accepts two arguments. If the first argument is NaN (not a number), it returns the second argument. If the first argument is a number, then it simply returns that number.
Note that this function is useful only for floating-point numbers of type BINARY_FLOAT or BINARY_DOUBLE.
SQRT() Function in Oracle
In Oracle, the SQRT() function returns the square root of its argument.
REPLACE() Function in Oracle
In Oracle, the REPLACE() function allows you to replace a part of a string with another string.
The function accepts three arguments: the string, the substring to replace, and the replacement string (to replace the substring with).
You can omit the replacement string, in which case, the function will remove all instances of the substring.
Continue readingLOWER() Function in Oracle
In Oracle, the LOWER() function returns its argument with all letters in lowercase.
UPPER() Function in Oracle
In Oracle, the UPPER() function returns its argument with all letters in uppercase.
NLS_INITCAP() Function in Oracle
In Oracle, the NLS_INITCAP() function returns its argument with the first letter of each word in uppercase, and all other letters in lowercase.
However, the actual capitalisation will depend on the collation being used. For example, it could result in more than the first letter being capitalised.
It’s similar to the INITCAP() function, except that it accepts a second argument that allows you to specify the collation. The collation handles special linguistic requirements for case conversions.
INITCAP() Function in Oracle
In Oracle, the INITCAP() function returns its argument with the first letter of each word in uppercase, and all other letters in lowercase.
For special linguistic requirements for case conversions, you may want to try the NLS_INITCAP() function instead.