Oracle ABS(n)

ABS(n)

 

ABS returns the absolute value of n.

 

절대값을 return

 

 

SQL>SELECT ABS('-1000.99999') FROM DUAL ;

   --> 1000.99999

 

SQL>SELECT ABS('A') FROM DUAL ;

 

--> ORA-01722: invalid number 를 발생시킨다.