ASIN

The ASIN function returns the arc sine of Expression.

SQL syntax

ASIN(Expression)

Parameters

ASIN has the parameter:

Parameter Description

Expression

Operand or column can be any numeric data type or any non-numeric data type that can be implicitly converted to a numeric data type.

Description

  • Expression must be in the range of -1 to 1. ASIN returns a value in the range of -pi/2 to pi/2, expressed in radians.

  • If Expression is of type NUMBER, the data type returned is NUMBER. For all other numeric data types, the data type returned is BINARY_DOUBLE.

  • If the value of Expression is NULL, NULL is returned.

Example

Use the ASIN function to return the arc sine of .3.

Command> SELECT ASIN(.3) "Arc sine of .3" FROM dual;
< .3046926540153975079720029612275291599 >
1 row found.