Math Functions in oracle | Math Functions | Numeric OR Mathematical Function - oracle tutorial - sql tutorial



What is Math Functions in oracle ?

  • Oracle SQL Mathematical functions are used primarily for numeric manipulation and/or mathematical calculations.
  • The following table defines the numeric functions.

ABS()

 oracle abs function

ACOS()

  • Returns the arccosine of numeric expression. Returns NULL if the value is not in the range -1 to 1.
 oracle acos function

ASIN()

  • Returns the arcsine of numeric expression. Returns NULL if value is not in the range -1 to 1.
 oracle asin function
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

ATAN()

  • Returns the arctangent of numeric expression
 oracle atan function

ATAN2()

  • Returns the arctangent of the two variables passed to it

BIT_AND()

  • Returns the bitwise AND all the bits in expression
 oracle bitand function

BIT_COUNT()

  • Returns the string representation of the binary value passed to it

BIT_OR()

  • Returns the bitwise OR of all the bits in the passed expression

CEIL()

  • Returns the smallest integer value that is not less than passed numeric expression
 oracle ceil function
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

CEILING()

  • Returns the smallest integer value that is not less than passed numeric expression

CONV()

  • Convert numeric expression from one base to another

COS()

  • Returns the cosine of passed numeric expression. The numeric expression should be expressed in radians

COT()

  • Returns the cotangent of passed numeric expression.

DEGREES()

  • Returns numeric expression converted from radians to degrees.

EXP()

  • Returns the base of the natural logarithm (e) raised to the power of passed numeric expression
 oracle exp function
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

FLOOR()

  • Returns the largest integer value that is not greater than passed numeric expression

FORMAT()

  • Returns a numeric expression rounded to a number of decimal places

GREATEST()

  • Returns the largest value of the input expressions.

LEAST()

  • Returns the minimum-valued input when given two or more

LOG()

  • Returns the natural logarithm of the passed numeric expression
 oracle log function

LOG10()

  • Returns the base-10 logarithm of the passed numeric expression
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

MOD()

  • Returns the remainder of one expression by diving by another expression.
 oracle mod function

PI()

  • Returns the value of pi.

POW()

  • Returns the value of one expression raised to the power of another expression

POWER()

  • Returns the value of one expression raised to the power of another expression
 oracle power function

RADIANS()

  • Returns the value of passed expression converted from degrees to radians

ROUND()

  • Returns numeric expression rounded to an integer. Can be used to round an expression to a number of decimal points
 oracle round function
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

SIN()

  • Returns the sine of numeric expression given in radians.

SQRT()

  • Returns the non-negative square root of numeric expression
 oracle sort function

STD()

  • Returns the standard deviation of the numeric expression

TAN()

  • Returns the tangent of numeric expression expressed in radians.
 oracle tan function

TRUNCATE()

  • Returns numeric exp1 truncated to exp2 decimal places. If exp2 is 0, then the result will have no decimal point
 oracle trunc function

Max Function:

  • The Oracle/PLSQL MAX function returns the maximum value from the particular or multiple columns.
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

Syntax:

SELECT MAX(aggregate_expression)
FROM tables
[WHERE conditions];
click below button to copy the code. By - oracle tutorial - team

Example:

SELECT 
MAX(salary) AS "Highest Salary"
FROM wikitechy_employee
group by name;
click below button to copy the code. By - oracle tutorial - team

Sample Database

  • For better understanding we are using wikitechy_employee table.
 mathematical database


Code Explanation:

 mathematical code explannation
  1. We have aliased the MAX(salary) expression as "Highest Salary". As a result, "Highest Salary" will display as the field name when the result set is returned.
  2. You can find the maximum salary as highest salary.

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning

Related Searches to Math Functions | Numeric OR Mathematical Function