Name | Type | Syntax | Returns |
| ABS | Number | ABS(n) | Absolute value of n. |
| ADD_MONTHS | Date | ADD_MONTHS(a,b) | Date a plus b months. |
| ASCII | Character | ASCII(c) | Decimal representation of c. |
| AVG | Group | AVG(DISTINCT|ALL n) | Average value of n. ALL is default. |
| CEIL | Number | CEIL(n) | Smallest integer equal to or greater than n. |
| CHARTOROWID | Conversion | CHARTOROWID(c) | Converts character to rowid data type. |
| CHR | Character | CHR(n) | Character having binary equivalent to n. |
| CONCAT | Character | CONCAT(1,2) | Character 1 concatenated with character 2. |
| CONVERT | Conversion | CONVERT(a, | Converts character |
|
|
| dest_c [,source_c]) | string a from one character set to another. The source source_c to the destination character set dest_c. |
| COS | Number | COS(n) | Cosine of n. |
| COSH | Number | COSH(n) | Hyperbolic cosine of n. |
| COUNT | Group | COUNT(DISTINCT|ALL e) | Number of rows in a query. ALL is default. e can be represented as * to indicate all columns. |
| EXP | Number | EXP(n) | e raised to the nth power. |
| FLOOR | Number | FLOOR(n) | Largest integer equal to or less than n. |
| GREATEST | Other | GREATEST(e [,e]...) | The greatest of the list of expressions e. |
| HEXTORAW | Conversion | HEXTORAW(c) | Converts hexadecimal character c to raw. |
| INITCAP | Character | INITCAP(c) | c with the first letter of each word in uppercase. |
| INSTR | Character | INSTR | Searches 1 with |
|
|
| (1, 2 [, n [, m]]) | nth character for mth occurrence of 2 and returns the position of the occurrence. |
| INSTRB | Character | INSTRB(1,2[,n[,m]]) | Same as INSTR except numeric parameters are in terms of bytes. |
| LAST_DAY | Dae | LAST_DAY(a) | Last day of the month (date) containing a. |
| LEAST | Other | LEAST(e [,e]...) | The least of the list of expressions e. |
| LENGTH | Character | LENGTH(c) | Number of characters in c. If c is a fixed-length data type (char), all trailing blanks are included. |
| LENGTHB | Character | LENGTHB(c) | Same as LENGTH except in bytes. |
| LN | Number | LN(n) | Natural logarithm if n, where n > 0. |
| LOG | Number | LOG(b,n) | Logarithm, base b, of n. |
| LOWER | Character | LOWER(c) | c with all letters in lowercase. |
| LPAD | Character | LPAD(1,n [,2]) | Character 1 left padded to length of n. If character 2 is not omitted, use as a pattern instead of blanks. |
| LTRIM | Character | LTRIM(c [,set]) | Removed characters from the left of c. If set s defined, remove initial characters up to the first character not in set. |
| MAX | Other | MAX(DISTINCT|ALL e) | Maximum of expression e. ALL is default. |
| MIN | Other | MIN(DISTINCT|ALL e) | Minimum of expression e. ALL is default. |
| MOD | Number | MOD(r,n) | Remainder of r divided by n. |
| MONTHS_BETWEEN | Date | MONTHS_BETWEEN(a,b) | Number of days between dates a and b. |
| NEW_TIME | Date | NEW_TIME(a, z1, z2) | Date and time in time zone z2 when date and time in time zone z1 are a). |
| NEXT_DAY | Date | NEXT_DAY(a, c) | Date of first weekday identified by c that is later than date a. |
| NLSSORT | Character | NLSSORT((c [,parm]) | String of bytes to sort c. |
| NLS_INITCAP | Character | NLS_INITCAP | c with the first |
|
|
| (c [,parm]) | letter of each word in uppercase. parm has the form of NLS_SORT = s where s is a linguistic sort or binary. |
| NLS_LOWER | Character | NLS_LOWER(c [,parm]) | c with all letters lowercase. See parm above. |
| NLS_UPPER | Character | NLS_UPPER(c [,parm]) | c with all letters uppercase. See parm above. |
| NVL | Other | NVL(e1, e2) | If e1 is null, returns e2. If e1 is not null, returns e1. |
| POWER | Number | POWER(m,n) | m raised to the nth power. |
| RAWTOHEX | Conversion | RAWTOHEX(raw) | Converts raw value to its hexadecimal equivalent. |
| REPLACE | Character | REPLACE(c, s1 [, r2]) | Replace each occurrence of string s1 in c with r2. If r2 is omitted then all occurrences of s1 are removed. |
| ROUND | Date | ROUND(n [,f]) | Date rounded to format model f. If f is omitted, n will be rounded to nearest day. |
| ROUND | Number | ROUND(n[,m]) | n rounded to m places right of decimal point. If m is omitted, to 0 places. |
| ROWIDTOCHAR | Conversion | ROWIDTOCHAR(rowid) | Converts rowid to varchar2 format with length of 18. |
| RPAD | Character | RPAD(1, n [, 2]) | 1 right-padded to length of n with 2. |
| RTRIM | Character | RTRIM(c [, s]) | c with characters removed after last character not in set s. If s is omitted, set defaulted to ''. |
| SIGN | Number | SIGN(n) | -1 if n <>n = 0, 1 if n > 0. |
| SIN | Number | SIN(n) | Sine of n. |
| SINH | Number | SINH(n) | Hyperbolic sine of n. |
| SOUNDEX | Character | SOUNDEX(c) | A string with phonetic representation of c. |
| SUBSTR | Character | SUBSTR(c, m [,n]) | A portion of c beginning at character number m for n characters. If m is negative, Oracle counts backward from the end of c. If n is omitted, all characters are returned to the end of c. |
| SUBSTRB | Character | SUBSTRB(c, m [,n]) | The same as SUBSTR except m and n are number of bytes. |
| SQRT | Number | SQRT(n) | Square root of n. |
| STDDEV | Group | STDDEV(DISTINCT|ALL n) | Standard deviation of number n. |
| SUM | Group | SUM(DISTINCT|ALL n) | Sum of numbers n. |
| SYSDATE | Date | SYSDATE | Current date and time. |
| TAN | Number | TAN(n) | Tangent of n. |
| TANH | Number | TANH(n) | Hyperbolic tangent of n. |
| TO_CHAR | Conversion | TO_CHAR | Converts d date to |
|
|
| (d [,f [,parm]) | varchar2 data type with format f and nls_date_language of parm. |
| TO_CHAR | Conversion | TO_CHAR | Converts n number |
|
|
| (n [,f [,parm]) | data type to a varchar2 equivalent and number format element parm. |
| TO_DATE | Conversion | TO_DATE | Converts varchar2 |
|
|
| (c [, f [, parm]) | data type c to date data type with format f and nls date format element parm. |
| TO_MULTI_BYTE | Conversion | TO_MULTI_BYTE(c) | Converts c to their corresponding multibyte equivalent. |
| TO_NUMBER | Conversion | TO_NUMBER | Converts character |
|
|
| (c [,f [, parm]]) | c to a number using format f and nls number format element parm. |
| TO_SINGLE_BYTE | Conversion | TO_SINGLE_BYTE(c) | Converts multibyte character c to its single byte equivalent. |
| TRANSLATE | Character | TRANSLATE(c, f, t) | c with each occurrences in f with each corresponding character in t. |
| TRUNC | Date | TRUNC(c [,f]) | c with time portion truncated to format f. |
| TRUNC | Number | TRUNC(n[,m]) | n truncated to m decimal places. If m is omitted, to 0 places. |
| UID | Other | UID | An integer that uniquely identifies the user. |
| USER | Other | USER | Current user as a varchar2. |
| UPPER | Character | UPPER(c) | c with all letters in uppercase. |
| VARIANCE | Group | VARIANCE | Variance of number |
|
|
| (DISTINCT|ALL n) | n. |
| VSIZE | Other | VSIZE(e) | Number of bytes from the internal representation of e. |