Description: An Oracle data types can be mapped to a number of DB2 data types. It is based on the data and select the appropriate data type to be matched. Here will use an integer or floating point real number to store it? And, here to note accuracy. Another area that needs attention is the use of space. For each DB2 space usage can vary according to the type of declaration: Smallint use two bytes, Integer using 4 bytes, Bigint using 8 bytes. For Oracle data type methods rely on space usage statement parameters. For the default precision 38 numbers you can use 20 bytes of storage space. Number mapped to Smallint. For instance, each block can save 18 bytes.
To Search:
File list (Check if you may need any files):
Oracle和DB2数据库对象和工具的比较和区别.doc
Download