개인적인 정리

ORACLE EXP() 본문

DB/ORACLE

ORACLE EXP()

yeon.Biju 2020. 3. 30. 10:05

오라클 EXP()

 

지수함수 정도 ?

 

EXP returns a raised to the nth power, where e=2.71828183... . The function returns a value of the same type as the argument.

 

This function takes as an argument any numeric data type or any nonnumeric data type that can be implicitly converted to a numeric data type. If the argument is BINARY_FLOAT, then the function returns BINARY_DOUBLE. Otherwise the functionk returns the same numeric data type as the argument.

 

 

SQL > SELECT EXP(4) FROM DUAL ;

   --> 54.5981500331442

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

Oracle GREATEST()  (0) 2020.03.30
ORACLE FLOOR()  (0) 2020.03.30
ORACLE FIRST()  (0) 2020.03.30
ORACLE EXTRACT()  (0) 2020.03.30
ORACLE EMPTY_BLOB(), EMPTY_CLOB()  (0) 2020.03.30
ORACLE DENSE_RANK()  (0) 2020.03.26
ORACLE DELETEXML()  (0) 2020.03.26
ORACLE DECODE()  (0) 2020.03.26
Comments