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 |