Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

Oracle

TANH Function in Oracle SQL – PLSQL

by

The TANH function in Oracle SQL / PLSQL is used to calculate hyperbolic tangent of numeric value where numeric value is provided in radian format.

It’s mathematically equal to TANH(N).

Syntax for the TANH function in Oracle SQL / PLSQL is:

SELECT TANH(radian)
FROM table_name;

Let’s take an example for understanding:

Suppose we want to get the hyperbolic tangent of 30 degree.

SELECT TANH(30*22/(7*180))
FROM dual;

The output of the above statement will be:

TANH(30*22/(7*180))
0.480634857866646

Notice that we have changed 30 degrees into radians while passing it in TANH function.

TAN Function in Oracle SQL – PLSQL

by

The TAN function in Oracle SQL / PLSQL is used to calculate tangent of numeric value where numeric value is provided in radian format.

It’s mathematically equal to TAN(N).

Syntax for the TAN function in Oracle SQL / PLSQL is:

SELECT TAN(radian)
FROM table_name;

Let’s take an example for understanding:

Suppose we want to get the tangent of 30 degree.

SELECT TAN(30*22/(7*180))
FROM dual;

The output of the above statement will be:

TAN(30*22/(7*180))
0.57763130100345

Notice that we have changed 30 degrees into radians while passing it in TAN function.

SINH Function in Oracle SQL – PLSQL

by

The SINH function in Oracle SQL / PLSQL is used to calculate hyperbolic sine of numeric value where numeric value is provided in radian format.

It’s mathematically equal to SINH(N).

Syntax for the SINH function in Oracle SQL / PLSQL is:

SELECT SINH(radian)
FROM table_name;

Let’s take an example for understanding:
Suppose we want to get the hyperbolic sine of 30 degree.

SELECT SINH(30*22/(7*180))
FROM dual;

The output of the above statement will be:

SINH(30*22/(7*180))
0.548093789242759

Notice that we have changed 30 degrees into radians while passing it in SINH function.

SIN Function in Oracle SQL – PLSQL

by

The SIN function in Oracle SQL / PLSQL is used to calculate sine of numeric value where numeric value is provided in radian format.

It’s mathematically equal to SIN(N).

Syntax for the SIN function in Oracle SQL / PLSQL is:

SELECT SIN(radian)
FROM table_name;

Let’s take an example for understanding:

Suppose we want to get the sine of 30 degree.

SELECT SIN(30*22/(7*180))
FROM dual;

The output of the above statement will be:

SIN(30*22/(7*180))
0.50018250219967

Notice that we have changed 30 degrees into radians while passing it in SIN function.

COSH Function in Oracle SQL – PLSQL

by

The COSH function in Oracle SQL / PLSQL is used to calculate hyperbolic cosine of numeric value where numeric value is provided in radian format.

It’s mathematically equal to COSH(N).

Syntax for the COSH function in Oracle SQL / PLSQL is:

SELECT COSH(radian)
FROM table_name;

Let’s take an example for understanding:

Suppose we want to get the hyperbolic cosine of 30 degree.

SELECT COSH(30*22/(7*180))
FROM dual;

The output of the above statement will be:

COSH(30*22/(7*180))
1.14035380553865

Notice that we have changed 30 degrees into radians while passing it in COSH function.