Oracle与SqlServer数据字段名对应表

来源:互联网 发布:win10平板手势软件 编辑:程序博客网 时间:2024/05/16 17:12
列名SqlServer数据类型SqlServer长度Oracle数据类型column1bigint8    NUMBER(19)column2binary50    RAW(50)column3bit1    NUMBER(2)column4char10    CHAR(10)column5datetime8    DATEcolumn6decimal9    NUMBER(18)column7float8 BINARY_DOUBLEcolumn8image16    BLOBcolumn9int4    NUMBER(10)column10money8  NUMBER(19,4)column11nchar10  NCHAR(10)column12ntext16  NCLOBcolumn13numeric9 NUMBER(18)column14nvarchar50 NVARCHAR2(50)column15real4 BINARY_FLOATcolumn16smalldatetime4 DATEcolumn17smallint2 NUMBER(5)column18smallmoney4 NUMBER(10,4)column19sql_variant  BLOBcolumn20text16 CLOBcolumn21timestamp8 RAW(8)column22tinyint1 NUMBER(3)column23uniqueidentifier16 BLOBcolumn24varbinary50 RAW(50)column25varchar50 VARCHAR2(50)
0 0
原创粉丝点击