Oracle (number) V. S. DB2 (decimal)

Number () in Oracle and decimal () in DB2)
1. in Oracle, number () is rounded down.

2. DB2 decimal () directly truncates the number following the number of valid digits without rounding.

Http://cache.baidu.com/C? M = listen & P = 93759a46d0c114f312be9b745f52cd & User = Baidu & fm = SC & query = decimal % 2816% 2C + 2% 29 + DB2 & qid = b79ff15c01_a2a5 & p1 = 1

 

Sqlplus UID/pass [@ dbname (not on the same machine)] can log on normally for verificationOracle;

Run the proc command to verifyOracleWhether the development environment can be used and its version number

 

Dbaccess (or iSQL tool) for database connection, used to verify INFOrThe running environment of mix;

Run esql-V to verify whether esql can be used and the version number;

 

RunDB2ConnectDBName [user uid using passwOrD. Connect the command to the database and verify the connection.DB2Whether the environment can be used;

RunDB2Prep VerificationDB2Whether the development environment is installed;