Oracle-Only SQL Functions

Previous Next

The functions that can only be used when running on Oracle are as follows:

Oracle-only SQL functions

ADD_MONTHS

CHARTOROWID

CONVERT

COSH

INSTRB

LAST_DAY

LEAST

LENGTHB

LTRIM (1)

MONTHS_BETWEEN

NEW_TIME

NEXT_DAY

NLS_INITCAP

NLS_LOWER

NLS_UPPER

NLSSORT

RAWTOHEX

ROWIDTOCHAR

RTRIM (1)

SINH

SUBSTRB

TANH

TO_CHAR

TO_CLOB (Oracle 9)

TO_DATE

TO_MULTI_BYTE

TO_NUMBER

TO_SINGLE_BYTE

TRANSLATE

TRUNC

USERENV

VSIZE

 

NOTE: On Oracle, LTRIM and RTRIM can have an optional second parameter. For more information, see your Oracle documentation.