Oracle ASIN() function
Description
The ASIN() is used to calculate the angle value (in radians) of a specified sine. The function returns a value in the range of -pi/2 to pi/2, expressed in radians and returns an error message when the value of the number is not between the ranges -1 to 1.
The function takes any numeric or nonnumeric data type (can be implicitly converted to a numeric data type) as an argument.
If the argument is BINARY_FLOAT, then the function returns BINARY_DOUBLE. Otherwise, the function returns the same numeric data type as the argument.
Syntax:
ASIN(N)
Parameters:
Name | Description |
---|---|
N | A number whose arch sine value is to be retrieved. |
Pictorial Presentation of ASIN() function

Example
The statement below will return an error because the number specified as an argument is exceeding the range which can be accepted.
SELECT ASIN(4) FROM dual;
Here is the result.
SELECT ASIN(4) FROM dual * ERROR at line 1: ORA-01428: argument '4' is out of range
Example: ASIN() function using fractional number
The statement below will return the arc sine value of the number specified as an argument.
SELECT ASIN(.4) FROM dual;
Sample Output:
ASIN(.4) ---------- .411516846
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook