«Back to Home

Oracle Jump Start
Topics

How To Use ASIN Function In OraclePLSQL

Description
 
ASIN function returns the arc sine of n, where n represents the number. This is the numeric Math function in Oracle/PLSQL. N must be in range -1 to 1 and this function returns a value in the range of –pi/2 to pi/2.
 
Syntax
 
The syntax of ASIN function in Oracle/PLSQL is given below-
  1. ASIN (Number)  
Example
  1. Select ASIN (.1)  
  2. from Dual;  
1
 
Let’s take another example of ASIN functions, which are given below-
 
Example
  1. Select ASIN (0)  
  2. from Dual;  
2

Example
  1. Select ASIN (1)  
  2. from Dual;  
3
 
Example
  1. Select ASIN (3)  
  2. from Dual;  
4

Summary
 
Thus we learnt, ASIN function returns the arc sine of n, where n represents the number. We learnt, how to use ASIN function in Oracle with the examples.