当数据从SQL SERVER2000向ORACLE 10g迁移时,可以做如下调整:
| SQL SERVER | ORACLE |
数字类型 | decimal [(P[, S])] | NUMBER[(P[, S])] |
numeric [(P[, S])] | NUMBER[(P[, S])] |
float[(N)] | NUMBER[(N)] |
real[(N)] | NUMBER[(N)] |
int | NUMBER |
smallint | NUMBER |
tinyint | NUMBER |
money | NUMBER[19,4] |
smallmoney | NUMBER[19,4] |
字符类型 | char[(N)] | CHAR[(N)] |
varchar[(N)] | VARCHAR2[(N)] |
nchar[(N)] | CHAR[(N)] |
nvarchar[(N)] | VARCHAR2[(N)] |
日期时间类型 | datetime | TIMESTAMP(6) |
smalldatetime | TIMESTAMP(6) |
其它 | text | CLOB |
image | BLOB |
bit | NUMBER(1) |