what is – Page 101

SUBSTR() Function in Oracle

August 1, 2021July 31, 2021 by Ian

In Oracle, the SUBSTR() function returns a substring from a given string.

SUBSTR() requires at least two arguments; the string, and the position for which to extract the substring from. It also accepts an optional third argument that allows you to specify how long the substring should be.

SUBSTR() can also be thought of as a group of functions. There are five separate functions; SUBSTR(), SUBSTRB(), SUBSTRC(), SUBSTR2(), and SUBSTR4(). Each function calculates the length in a different way.

CONCAT() Function in Oracle

July 30, 2021 by Ian

In Oracle, the CONCAT() function performs a string concatenation on its arguments. It returns the string that results from concatenating its arguments.

Concatenation is the operation of joining multiple strings end-to-end.

WIDTH_BUCKET() Function in Oracle

July 30, 2021 by Ian

In Oracle, the WIDTH_BUCKET() function allows you to construct equiwidth histograms, in which the histogram range is divided into intervals that have identical size.

For a given expression, WIDTH_BUCKET() returns the bucket number into which the value of this expression would fall after being evaluated.

TRUNC(number) Function in Oracle

August 5, 2021July 29, 2021 by Ian

In Oracle Database, the TRUNC(number) function returns a given number, truncated to a given number of decimal places.

Oracle also has a TRUNC(date) function, which is used on dates. This article is solely about the TRUNC(number) function, which is used on numbers.

SIGN() Function in Oracle

July 29, 2021 by Ian

In Oracle, the SIGN() function returns the sign of its argument as -1, 0, or 1, depending on whether the argument is negative, zero, or positive, and also depending on whether the argument is of type NUMBER or a floating-point number.

TANH() Function in Oracle

July 28, 2021 by Ian

In Oracle, the TANH() function returns the hyperbolic tangent of its argument.

TAN() Function in Oracle

July 28, 2021 by Ian

In Oracle, the TAN() function returns the tangent of its argument, where the argument is an angle expressed in radians.

NANVL() Function in Oracle

July 27, 2021 by Ian

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

July 27, 2021 by Ian

In Oracle, the SQRT() function returns the square root of its argument.

REPLACE() Function in Oracle

July 27, 2021July 26, 2021 by Ian

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.