Function
The SQL syntax elements for Oracle Version 7 and SAP MaxDB in the ORACLE SQL mode differ, among other things, in the definition of functions.
The following Oracle functions are not available as functions in SAP MaxDB:
- CHARTOROWID
- ROWIDTOCHAR
- CONVERT
- DUMP
- USERENV
- NLS_INITCAP
- NLS_LOWER
- NLS_UPPER
- TO_MULTI_BYTE
- TO_SINGLE_BYTE
- INSTRB
- LENGTHB
- SUBSTRB
When the string
functions LPAD and RPAD are
specified in SAP MaxDB, the character string x
cannot
be longer than n
.
When string function SUBSTR is
specified in SAP MaxDB, a
cannot be less than 1
.
When the function INSTR
is specified
in MaxDB, the parameter "n
" must not be smaller
than 1
.
When the functions TO_CHAR
, TO_DATE
and TO_NUMBER
are specified in MaxDB, the parameter "nlsparams
"
is not available.