Functions
Functions, like operators, act on data to return a result. However, unlike operators, functions can operate on zero, one, or more arguments. Of the built in SQL functions in Oracle 9i, there are single row functions, aggregate functions, analytical functions and object reference functions. User defined functions, that can be written in PL/SQL or Java in Oracle 9i, are not covered here.
Single Row Functions
Number Functions
| Function | What it does |
|---|---|
| ABS(n) | Returns absolute value of n |
| ACOS(n) | Returns arc cosine of n in radians |
| ASIN(n) | Returns arc sine of n in radians |
| ATAN(n) | Returns arc tangent of n, in radians |
| ATAN2(n,m) | Returns the arc tangent of n and m, in radians |
| BITAND(n,m) | Computes the bitwise logical AND of ... |
Get Oracle® DBA SQL Quick Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
