Oracle SINH, COSH, and TANH Functions with ExamplesIn 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_VALUECOSH_VALUETANH_VALUE
1.1752011941.5430806350.761594156

 

Example 2

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

Result:

SINH_VALUECOSH_VALUETANH_VALUE
010

 

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_VALUECOSH_VALUE_1TANH_VALUE_2
36.843112573637665.9790.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!

Want To Improve Your Oracle SQL?

Improve your Oracle SQL queries by signing up to my free 10-day Oracle Tips email course.

BONUS: Oracle SQL functions PDF cheat sheet

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit