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 | DATE | |||||
column6 | decimal | 9 | NUMBER(18) | ||||
column7 | float | BINARY_DOUBLE | |||||
column8 | image | 16 | BLOB | ||||
column9 | int | 4 | NUMBER(10) | ||||
column10 | money | NUMBER(19,4) | |||||
column11 | nchar | NCHAR(10) | |||||
column12 | ntext | NCLOB | |||||
column13 | numeric | column14 | nvarchar | NVARCHAR2(50) | |||
column15 | real | BINARY_float | |||||
column16 | smalldatetime | column17 | smallint | 2 | NUMBER(5) | ||
column18 | smallmoney | NUMBER(10,sans-serif; background-color:transparent"> column19 | sql_variant | column20 | text | CLOB | |
column21 | timestamp | RAW(8) | |||||
column22 | tinyint | NUMBER(3) | |||||
column23 | uniqueIDentifIEr | column24 | varbinary | column25 | varchar | VARCHAR2(50) |
Oracle 10g 转换为sqlServer 2k
Oracle列名 | Oracle数据类型 | sqlServer列名 | @H_526_419@ sqlServer数据类型 @H_526_419@ sqlServer数据长度||||||||||||
ColUMN1 | BINARY_DOUBLE | 8 | ||||||||||||
ColUMN2 | BINARY_float | 4 | ||||||||||||
ColUMN3 | BLOB | 16 | ||||||||||||
ColUMN4 | CLOB | ColUMN5 | CHAR(10) | 10 | ||||||||||
ColUMN6 | DATE | ColUMN12 | NUMBER | 13 | ||||||||||
ColUMN13 | NVARCHAR2(10) | ColUMN14 | RAW(10) | ColUMN15 | TIMESTAMP(6) | ColUMN16 | TIMESTAMP(6) WITH LOCAL TIME ZONE | ColUMN17 | TIMESTAMP(6) WITH TIME ZONE | ColUMN18 | VARCHAR2(10) | ColUMN7 | INTERVAL DAY(2) TO SECOND(6) | 30 |
ColUMN8 | INTERVAL YEAR(2) TO MONTH | 14 | ||||||||||||
ColUMN9 | LONG | ColUMN10 | LONG RAW | ColUMN11 | NCLOB | 16 |
以上是内存溢出为你收集整理的SqlServer与Oracle相互迁移的数据类型对比全部内容,希望文章能够帮你解决SqlServer与Oracle相互迁移的数据类型对比所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)