oracle uniqueidentifier,SQL Server 和Oracle 数据类型对应

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