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.