Select Page

In this article, I’ll cover what the Oracle SINH, COSH, and TANH functions are, and show you some examples.

## Purpose of the Oracle SINH, COSH, and TANH Functions

These three functions are used to calculate the hyperbolic sine, cosine, or tangent of a number:

• SINH: Calculate the hyperbolic sine of a number
• COSH: Calculate the hyperbolic cosine of a number
• TANH: Calculate the hyperbolic tangent of a number

If you’re not sure what a hyperbolic sine, cosine, or tangent is, you can find out here.

## Syntax

The syntax of these three functions are similar:

SINH (number)

COSH (number)

TANH (number)

## Parameters

The parameters of the three functions are similar.

For the SINH function, the parameters are:

• number (mandatory): The value used to calculate the hyperbolic sine.

For the COSH function, the parameters are:

• number (mandatory): The value used to calculate the hyperbolic cosine.

For the TANH function, the parameters are:

• number (mandatory): The value used to calculate the hyperbolic tangent.

The parameter can be any numeric data type. The return value is in the same data type as the specified data type, unless the specified data type is BINARY_FLOAT. In that case, the return type is BINARY_DOUBLE.

## Examples of the SINH, COSH, and TANH Function

Here are some examples of these three functions.

### Example 1

``````SELECT
SINH(1) AS sinh_value,
COSH(1) AS cosh_value,
TANH(1) AS tanh_value
FROM dual;``````

Result:

 SINH_VALUE COSH_VALUE TANH_VALUE 1.175201194 1.543080635 0.761594156

### Example 2

``````SELECT
SINH(0) AS sinh_value,
COSH(0) AS cosh_value,
TANH(0) AS tanh_value
FROM dual;``````

Result:

 SINH_VALUE COSH_VALUE TANH_VALUE 0 1 0

### Example 3

``````SELECT
SINH(4.3) AS cosh_value,
COSH(15.8) AS cosh_value,
TANH(9.1) AS cosh_value
FROM dual;``````

Result:

 SINH_VALUE COSH_VALUE_1 TANH_VALUE_2 36.84311257 3637665.979 0.9999999751

## Similar Functions

Some functions which are similar to the SINH, COSH, and TANH functions are:

• SIN: Returns the sine of a number.
• TAN: Returns the tangent of a number.
• COS: Returns the cosine of a number.
• ASIN: Returns the arc sine of a number.
• ACOS: Returns the arc cosine of a number.
• ATAN: Returns the arc tangent of a number/

If you want to know more about SQL functions, you can find a full list of Oracle SQL functions here.

Lastly, if you enjoy the information and career advice I’ve been providing, sign up to my newsletter below to stay up-to-date on my articles. You’ll also receive a fantastic bonus. Thanks!

x