Background documentationNumber Locate this document in the navigation structure

 

The SQL syntax elements for Oracle Version 7 and SAP MaxDB in ORACLE SQL mode differ, among other things, in the definition of numbers.

  • For Oracle, the permitted value range for numbers covers values from 0.999E-128 to 0.999E126.

  • In SAP MaxDB, the permitted value range for floating point numbers (number) consists of the interval from -9.9999999999999999999999999999999999999E+62 to -1E-64, the value 0.0, and the interval from +1E-64 to +9.9999999999999999999999999999999999999E+62.

More Information

SQL Syntax Elements: Differences