The SINH function in Oracle SQL is a mathematical function that returns the hyperbolic sine of a number.
This is an exponential function used in engineering, physics, and complex mathematics, and is different from the standard SIN (sine) function.
What is the SINH Function in Oracle?
The SINH(n) function takes a number n and returns its hyperbolic sine. The calculation is equivalent to:
(EXP(n) - EXP(-n)) / 2
Where EXP is the e (Euler's number) raised to the power of n.
SINH Function Syntax
The syntax for SINH is very simple:
SINH(n)
Let's break that down:
n(the number): The number for which you want to find the hyperbolic sine.
Oracle SINH Function Examples
Here are two practical examples of how to use SINH.
Example 1: Finding the Hyperbolic Sine of 1
This example calculates the hyperbolic sine of the number 1.
Query:
SELECT
SINH(1) AS "Hyperbolic_Sine_of_1"
FROM DUAL;
Result:
Hyperbolic_Sine_of_1
--------------------
1.17520119
Example 2: Finding the Hyperbolic Sine of 0
This example calculates the hyperbolic sine of 0, which is always 0.
Query:
SELECT
SINH(0) AS "Hyperbolic_Sine_of_0"
FROM DUAL;
Result:
Hyperbolic_Sine_of_0
--------------------
0
