Default Data Type Mappings Used by Oracle SQL Developer
http://download.oracle.com/docs/cd/E12151_01/doc.150/e12155/oracle_mysql_compared.htm#BABDFGBD[@more@]
Table 2-4 Default Data Type Mappings Used by Oracle SQL Developer
| MySQL Data Type | Oracle Data Type |
|---|---|
BIGINT | NUMBER(19, 0) |
BIT | RAW |
BLOB | BLOB, RAW |
CHAR | CHAR |
DATE | DATE |
DATETIME | DATE |
DECIMAL | FLOAT (24) |
DOUBLE | FLOAT (24) |
DOUBLE PRECISION | FLOAT (24) |
ENUM | VARCHAR2 |
FLOAT | FLOAT |
INT | NUMBER(10, 0) |
INTEGER | NUMBER(10, 0) |
LONGBLOB | BLOB, RAW |
LONGTEXT | CLOB, RAW |
MEDIUMBLOB | BLOB, RAW |
MEDIUMINT | NUMBER(7, 0) |
MEDIUMTEXT | CLOB, RAW |
NUMERIC | NUMBER |
REAL | FLOAT (24) |
SET | VARCHAR2 |
SMALLINT | NUMBER(5, 0) |
TEXT | VARCHAR2, CLOB |
TIME | DATE |
TIMESTAMP | DATE |
TINYBLOB | RAW |
TINYINT | NUMBER(3, 0) |
TINYTEXT | VARCHAR2 |
VARCHAR | VARCHAR2, CLOB |
YEAR | NUMBER |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7591490/viewspace-1026395/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle高可用环境之DDL操作
下一篇：
文件操作之flock
请登录后发表评论
登录
全部评论
