In Oracle, the TRIM() function allows you to trim characters from the sides of a string.
You can trim leading characters, trailing characters, or both.
By default, it trims white space, but you can optionally specify a different character or characters to trim.
Continue readingIn Oracle, the LTRIM() function allows you to trim the left part of a string. By default, it trims white space, but you can optionally specify a different character or characters to trim.
In Oracle, the RTRIM() function allows you to trim the right part of a string. By default, it trims white space, but you can optionally specify a different character or characters to trim.
In Oracle, the SINH() function returns the hyperbolic sine of its argument.
In Oracle, the SIN() function returns the sine of its argument, where the argument is an angle expressed in radians.
In Oracle, the POWER() function returns its first argument raised to the power of its second argument.
In Oracle, the REMAINDER() function returns the remainder of its first argument divided by its second.
It’s similar to the MOD() function, except that it uses ROUND() in its calculation, whereas MOD() uses FLOOR() in its calculation.
In Oracle, the MOD() function returns the modulo operation. In other words, it returns the remainder of its first argument divided by its second.
In Oracle, the EXP() function returns the value of e (the base of natural logarithms) raised to the power of the argument.
The number e, also known as Euler’s number, is a mathematical constant approximately equal to 2.71828.
Continue readingIn Oracle, the COSH() function returns the hyperbolic cosine of its argument.