SqlServer 2k转换为Oracle 10g
列名
SqlServer数据类型
SqlServer长度
Oracle数据类型
column1
bigint
8
NUMBER(19)
column2
binary
50
RAW(50)
column3
bit
1
NUMBER(2)
column4
char
10
CHAR(10)
column5
datetime
8
DATE
column6
decimal
9
NUMBER(18)
column7
float
8
BINARY_DOUBLE
column8
image
16
BLOB
column9
int
4
NUMBER(10)
column10
money
8
NUMBER(19,4)
column11
nchar
10
NCHAR(10)
column12
ntext
16
NCLOB
column13
numeric
9
NUMBER(18)
column14
nvarchar
50
NVARCHAR2(50)
column15
real
4
BINARY_FLOAT
column16
smalldatetime
4
DATE
column17
smallint
2
NUMBER(5)
column18
smallmoney
4
NUMBER(10,4)
column19
sql_variant
BLOB
column20
text
16
CLOB
column21
timestamp
8
RAW(8)
column22
tinyint
1
NUMBER(3)
column23
uniqueidentifier
16
BLOB
column24
varbinary
50
RAW(50)
column25
varchar
50
VARCHAR2(50)
Oracle 10g 转换为SqlServer 2k
Oracle列名|Oracle数据类型|SqlServer列名|SqlServer数据类型|SqlServer数据长度
----|------|-----|----
COLUMN1|BINARY_DOUBLE|COLUMN1|float|8
COLUMN2|BINARY_FLOAT|COLUMN2|real|4
COLUMN3|BLOB|COLUMN3|image|16
COLUMN4|CLOB|COLUMN4|ntext|16
COLUMN5|CHAR(10)|COLUMN5|nchar|10
COLUMN6|DATE|COLUMN6|datetime|8
COLUMN12|NUMBER|COLUMN12|numeric|13
COLUMN13|NVARCHAR2(10)|COLUMN13|nvarchar|10
COLUMN14|RAW(10)|COLUMN14|varbinary|10
COLUMN15|TIMESTAMP(6)|COLUMN15|datetime|8
COLUMN16|TIMESTAMP(6) WITH LOCAL TIME ZONE|COLUMN16|datetime|8
COLUMN17|TIMESTAMP(6) WITH TIME ZONE|COLUMN17|datetime|8
COLUMN18|VARCHAR2(10)|COLUMN18|nvarchar|10
COLUMN7|INTERVAL DAY(2) TO SECOND(6)|COLUMN7|nvarchar|30
COLUMN8|INTERVAL YEAR(2) TO MONTH|COLUMN8|nvarchar|14
COLUMN9|LONG|COLUMN9|ntext|16
COLUMN10|LONG RAW|COLUMN10|image|16
COLUMN11|NCLOB|COLUMN11|ntext|16