Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Math FunctionsRSS Feeds

NUMERIC FUNCTIONS

Posted By: Thomas Evans     Category: Oracle     Views: 1834

NUMERIC FUNCTIONS in oracle

ABS : returns the absolute value of 'n'

SELECT ABS(-15) "Absolute" FROM dual;

POWER(m,n) : returns m raised to the nth power,n must be integer

SELECT POWER(3,2) "raised" FROM dual;

ROUND(n,m) : returns n rounded to m places to the right of decimal point.

SELECT ROUND(15.19,1) FROM DUAL;
SELECT ROUND(15.15,1) FROM DUAL;

SQRT :

SELECT SQRT(25) FROM DUAL;

  
Share: 


Didn't find what you were looking for? Find more on NUMERIC FUNCTIONS Or get search suggestion and latest updates.

Thomas Evans
Thomas Evans author of NUMERIC FUNCTIONS is from London, United Kingdom.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!