The SQL syntax elements for Oracle Version 7 and SAP DB Version 7.3 in SQL mode ORACLE differ, among other things, in the definition of data types.

• In contrast to Oracle, columns with the data type CHAR[ACTER] are only stored up to a length of 30 characters with fixed length in SAP DB.
• The data type VARCHAR2 does not differ from VARCHAR in SAP DB.
• In SAP DB, the data type INT[EGER] is restricted to the area from -2147483648 to 2147483647.
• In SAP DB, the data type SMALLINT is restricted to the area from -32768 to 32767.
• In SAP DB, the data type FLOAT is always represented with 20 significant digits.
• In SAP DB, data types cannot be defined for numbers with a negative scale. It is not possible to specify a scale that is greater than the number of significant digits.
• In SAP DB, numbers are not implicitly converted into date values or vice versa.
• In Oracle, date values extend from 1.1.4712 BC to 31.12.4712 AD.
  In SAP DB, date values extend from 1.1.0001 to 31.12.9999.
• SAP DB does not support the comparison of character strings denoted as "non padded comparison" in Oracle.