개인적인 정리

ORACLE ASIN() 본문

DB/ORACLE

ORACLE ASIN()

yeon.Biju 2020. 3. 24. 08:45

오라클 ASIN 함수

 

ASIN returns the are sine of n. The argument n must be in the range of -1 to 1, and the function returns a value in the range of -pi / 2 to pi / 2, exrpessed in radians.

 

SQL> SELECT ASIN(.3) FROM DUAL ;

   --> 0.304692654015398

 

SQL> SELECT ASIN(-2) FROM DUAL ;

--> ORA-01428: argument '-2' is out of range 라는 오류가 발생.

'DB > ORACLE' 카테고리의 다른 글

ORACLE CAST()  (0) 2020.03.24
ORACLE AVG()  (0) 2020.03.24
ORACLE ATAN2()  (0) 2020.03.24
ORACLE ATAN()  (0) 2020.03.24
ORACLE ASCIISTR()  (0) 2020.03.24
ORACLE ASCII() 함수  (0) 2020.03.23
ORACLE APPENDCHILDXML() 함수  (0) 2020.03.23
ORACLE ADD_MONTHS(date, integer)  (0) 2020.03.20
Comments