DATABASE & SQL/PLSQL

Mathematical Functions
Previous Home Next

Mathematical function perform numerical operation on mathematical data. The various mathematical functions are:

Function NameParameterDescription
ABS (numeric_expression) Return an absolute value)
ACOS,ASIN, ATN (float_expression) Returns the angle in radians whose cosin,sin and tangent is a floating point value
COS,SIN,COT,TAN (float_expression) Returns the angle in radians whose cosin, sin, tangent and cot of the angle
DEGREES (numeric_expression) Returns the smallest integer greater than or equal to the specified value
EXP (float_expression) Return the exponential value of the specified value
FLOOR (numeric_expression) Return the largest integer less than or equal to the specified value.
LOG (float_expression) Return the natural logarithm of the specified value
LOG (float_expression) Return the natural logarithm of the specified value
LOG10 (float_expression) Return the base-10 logarithm of the specified value
PI () Returns the constant value of 3.141592653589793
POWER< (numeric_expression, y) Return the value of numeric_expression to the value of y
RADIANS< (numeric_expression) Convert from degrees to radians
RAND ([seed]) Return a random float number between 0 and 1
ROUND (numeric_expression, length) returns a numeric expression rounded off to the length specified as an integer expression
SIGN (numeric_expression) Returns positive, negative or zero
SQRT (float_expression) Return the square root of the specified value

 

ROUND (numeric_expression,length)

numeric_expression is the numeric expression to be round off

SELECT 'value'= ROUND (123.452352,3)

Out Put:

Previous Home Next

Tolal:0 Click:

Show All Comments

Did not find what you were looking for leave your name and message. We will revert within 24 hours
Name:
eMail:
Comment / Feedback: