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.
Object-Relational
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.
SET SQLBLANKLINES: How to Allow Blank Lines in SQLcl & SQL*Plus
If you’re trying to run a multi-line query in SQLcl or SQL*Plus, and you keep getting an error such as “Unknown Command”, but running it in SQL Developer causes no such error, maybe this post will help.
By default, SQLcl and SQL*Plus don’t allow blank lines in SQL statements. However, you can change this with the SET SQLBLANKLINES command.
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.
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.
EXP() Function in Oracle
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.
COSH() Function in Oracle
In Oracle, the COSH() function returns the hyperbolic cosine of its argument.