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 »

## PLSQL | CURRENT_DATE Function

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 »

## PLSQL | CURRENT_TIMESTAMP Function

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 »

## PLSQL | SINH Function

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 »

## PLSQL | TAN Function

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 »

## PLSQL | MOD Function

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 »

## PLSQL | POWER Function

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 »

## PLSQL | REMAINDER Function

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 »

## PLSQL | SQRT Function

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 »

## PLSQL | GREATEST Function

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 »

## PLSQL | BITAND Function

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 »

## PLSQL | LEAST Function

The LEASE 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 »

## PLSQL | UPPER Function

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 »

## PLSQL | ACOS Function

The PLSQL ACOS function is used to return the arc cosine of a number. The ACOS function only one parameter which is a number and… Read More »

## PLSQL | TRANSLATE Function

The PLSQL TRANSLATE function is used for replacing a sequence of characters in a string with another set of characters. The PLSQL TRANSLATE function replaces… Read More »