ASIN Function in Oracle SQL – PLSQL

The ASIN function in Oracle SQL / PLSQL is used to get arc sine of a number.

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

SELECT ASIN(N)
FROM table;

N is the number whose arc sine is to be determined.

Example 1:

SELECT ASIN(0.4)
FROM DUAL; 

Will return “0.411516846067488”

Example 2:

SELECT ASIN(0)
 FROM DUAL;

Will return “0”

Example 3:

SELECT ASIN(-0.4)
 FROM DUAL;

Will return “-0.411516846067488”