Background documentationFunction Locate this document in the navigation structure

 

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.

More Information

Functions: Overview

SQL Syntax Elements: Differences