In Oracle, the NCHR() function returns the character having the binary equivalent to its argument in the national character set.
It’s the equivalent of using the CHR() function with the USING NCHAR_CS argument.
Tag: what is
CHR() Function in Oracle
In Oracle, the CHR() function returns a character based on the code values provided as an argument.
More specifically, it returns the character having the binary equivalent to its argument as a VARCHAR2 value in either the database character set or, if you specify USING NCHAR_CS, the national character set.
TRIM() Function in Oracle
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 readingLTRIM() Function in Oracle
In 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.
RTRIM() Function in Oracle
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.
SINH() Function in Oracle
In Oracle, the SINH() function returns the hyperbolic sine of its argument.
SIN() Function in Oracle
In Oracle, the SIN() function returns the sine of its argument, where the argument is an angle expressed in radians.
POWER() Function in Oracle
In Oracle, the POWER() function returns its first argument raised to the power of its second argument.
REMAINDER() Function in Oracle
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.
MOD() Function in Oracle
In Oracle, the MOD() function returns the modulo operation. In other words, it returns the remainder of its first argument divided by its second.