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()
ACOS()
- Returns the arccosine of numeric expression. Returns NULL if the value is not in the range -1 to 1.
ASIN()
- Returns the arcsine of numeric expression. Returns NULL if value is not in the range -1 to 1.
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql
ATAN()
- Returns the arctangent of numeric expression
ATAN2()
- Returns the arctangent of the two variables passed to it
BIT_AND()
- Returns the bitwise AND all the bits in expression
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 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 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
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.
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
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 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
STD()
- Returns the standard deviation of the numeric expression
TAN()
- Returns the tangent of numeric expression expressed in radians.
TRUNCATE()
- Returns numeric exp1 truncated to exp2 decimal places. If exp2 is 0, then the result will have no decimal point
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.
Code Explanation:
- 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.
- You can find the maximum salary as highest salary.