Function | Parameters | Result |
---|---|---|

SIN (θ) | n = angle in radians | sine (θ) |

COS (θ) | n = angle in radians | cosine (θ) |

TAN (θ) | n = angle in radians | tan (θ) |

RADIANS(x) | x = angle in degree | Return value of x degree in radians |

ASIN (θ) | n is in the range -1 to +1 | arc sine of θ in the range -π/2 to +π/2 |

ACOS (θ) | θ is in the range -1 to +1 | arc cosine of θ in the range 0 to π |

ATAN (θ) | θ is unbounded | arc tangent of θ in the range -π/2 to + π/2 |

SINH (θ) | θ = value | hyperbolic sine of θ |

COSH (θ) | n = value | hyperbolic cosine of θ |

TANH (θ) | θ = value | hyperbolic tangent of θ |

ABS (x) | x = value | Absolute value of x |

MAX ( x ) | x = column name | Returns maximum value in a column |

MIN ( x ) | x = column name | Returns minimum value in a column |

MEDIAN ( x ) | x = column name | Returns middle value in a column |

MOD ( x, y ) | x = value, y = divisor | Remainder of x/y |

SUM ( x ) | x = name of the column | Returns SUM of all values in the column x |

AVG ( x ) | x = name of the column | Returns average of all values in the column x |

COALESCE ( x, y, z ) | x, y, z = name of the columns | Returns the first non-null values in the columns x |

POWER ( x, y ) | x = value, y = exponent | x^{y} |

ROUND ( x [, n ] ) | x = value, n = number of decimal places, default 0 | x rounded to the nth decimal place |

TRUNC ( x [, n ] ) | x = value, n = number of decimal places, default 0 | x truncated to the nth decimal place |

SQRT ( x ) | x = value | + √x |

STD(x) | x = list of values | Returns standard deviation of x |

EXP ( x ) | x = value | e^{x} |

LN ( x ) | x > 0 | natural logarithm of x |

LOG ( x2, x1 ) | base x2 any positive value other than 0 or 1, x1 any positive value | log_{x2}x1 |

GREATEST ( x1, x2, x3,x4) ) | x1, x2, x3, x4 = list of values | gives greatest value in the list |

LEAST ( x1, x2, x3,x4 ) | x = value | shows the least value in the list |

CEIL ( x ) | x = value | smallest integer >= x |

FLOOR ( x ) | x = value | greatest integer <= x |

SIGN ( x ) | x = value | -1 if x < 0, 0 if x = 0, and 1 if x > 0 |

Examples:

SELECT SQRT (49) FROM DUAL;

Output:7

SELECT ROUND (10.6328, 3) FROM DUAL;

Output:10.632

SELECT POWER (5, 4) FROM DUAL;

Output:625

SELECT MOD (32, 5) FROM DUAL;

Output:2

SELECT RADIANS (90);

Output:1.570796