The PLSQL TANH function is used to return the hyperbolic tangent of a numeric value. The TANH function accepts one parameter which is the number… Read More
Tag Archives: SQL-PL/SQL
The PLSQL SIGN function is used for returning a value which indicates the sign of a number. The SIGN function accepts one parameter which is… Read More
The PLSQL ADD_MONTHS function is used to return a date with a specified number of months added to it. The ADD_MONTHS function accepts two parameters… Read More
The PLSQL CURRENT_DATE function is used to return the current date in the session time zone. The time zone used is the time zone of… Read More
The PLSQL CURRENT_TIMESTAMP function is used to return the current date and time in session time zone. The time zone used is the time zone… Read More
The PLSQL SINH function is used to return the hyperbolic sine of a numeric value. The SINH function accepts one parameter which is the number… Read More
The TAN function is an inbuilt function in PLSQL which is used to return the tangent of an input number. The tangent is a trigonometric… Read More
The MOD function is an inbuilt function in PLSQL which is used to return the remainder when a is divided by b. Its formula is… Read More
The POWER function is an inbuilt function in PLSQL which is used to return the calculated value when a raised to the bth power. If… Read More
The REMAINDER function is an inbuilt function in PLSQL which is used to return the remainder of a divided by b. Syntax: REMAINDER(a, b) Parameters… Read More
The SQRT function is an inbuilt function in PLSQL which is used to return the square root of the given input number. Syntax: SQRT( number… Read More
The GREATEST is an inbuilt function in PLSQL which is used to return the greatest value from a given list of some expressions. These expressions… Read More
The BITAND is an inbuilt function in PLSQL which is used to returns an integer value which is calculated with AND operation of two given… Read More
The LEAST is an inbuilt function in PLSQL which is used to return the least value from a given list of some expressions. These expressions… Read More
The PLSQL UPPER function is used for converting all letters in the specified string to uppercase. If there are characters in the string that are… Read More