blenda

 Profile Answers by blenda Questions by blenda

• May 2nd, 2007

 

Every column in a database table is assigned a data type. The data type maybe native to the database management system, or may be a custom data type. Each Oracle9i Database native data type belongs to one of six categories: character, number, date, large object (LOB), raw, and row identifier. Oracle date data types only store valid dates, support automatic time zone conversion, and store sub-second precision. MySQL categorizes data types into string, numeric, and date and time types. Unlike Oracle, MySQL date data types can store invalid dates, do not support time zones, and the precision of time values is limited to one second.

StephenRaj

 Profile Answers by StephenRaj Questions by StephenRaj

• May 2nd, 2007

 

MySQL supports six different types of tables, four of which do not support transactions (MyISAM, MERGE, ISAM, and HEAP) and two of which support transactions (InnoDB and BDB). The multiple table types are a result of the initial MySQL design where fast, non-transactional tables were the only option. Because non-transactional tables do not support referential integrity, transactions, and hot backups, no mission-critical application development could utilize these tables.

Remasri

 Profile Answers by Remasri Questions by Remasri

• May 2nd, 2007

 

MySQL only supports one index type, but implements different data access paths using the various table types. The eight types of Oracle indexes are B-tree, B-tree Cluster, Hash Cluster, Reverse Key, Bitmap, Bitmap Join, Function-Based, and Domain.