F Quick Reference to Oracle SQL Functions

The following table lists the Oracle SQL functions in alphabetic order.

Table F-1 Oracle SQL Functions in Alphabetic Order

Function Name	Function Name	Function Name	Function Name
`ABS`	`ACOS`	`ADD_MONTHS`	`ASIN`
`ASCII`	`ATAN`	`ATAN2`	`CEIL`
`CHAR_TO_ROWID`	`CHR`	`CONVERT`	`COS`
`COSH`	`DECODE`	`DUMP`	`EXP`
`FLOOR`	`GREATEST`	`HEXTORAW`	`INITCAP`
`INSTR`	`INSTRB`	`LAST_DAY`	`LEAST`
`LENGTH`	`LENGTHB`	`LN`	`LOG`
`LOWER`	`LPAD`	`LTRIM`	`MOD`
`MONTHS_BETWEEN`	`NEW_TIME`	`NEXT_DAY`	`NLS_INITCAP`
`NLS_LOWER`	`NLS_UPPER`	`NLSSORT`	`POWER`
`RAWTOHEX`	`REPLACE`	`ROUND`	`ROWIDTOCHAR`
`RPAD`	`RTRIM`	`SIGN`	`SIN`
`SINH`	`SOUNDEX`	`SQRT`	`STDDEV`
`SUBSTR`	`SUBSTRB`	`SYSDATE`	`TAN`
`TANH`	`TO_CHAR`	`TO_DATE`	`TO_LABEL`
`TO_MULTI_BYTE`	`TO_NUMBER`	`TO_SINGLE_BYTE`	`TRANSLATE`
`TRUNC`	`UID`	`UPPER`	`USER`
`USERENV`	`VARIANCE`	`VSIZE`	`BITAND`