网站首页  汉语字词  英语词汇  考试资料  写作素材  旧版资料

请输入您要查询的范文:

 

标题 SQL Server 和Oracle 数据类型对应
范文
    SqlServer 2k转换为Oracle 10g
    列名SqlServer数据类型SqlServer长度Oracle数据类型
    column1bigint8NUMBER(19)
    column2binary50RAW(50)
    column3bit1NUMBER(2)
    column4char10CHAR(10)
    column5datetime8DATE
    column6decimal9NUMBER(18)
    column7float8BINARY_DOUBLE
    column8image16BLOB
    column9int4NUMBER(10)
    column10money8NUMBER(19,4)
    column11nchar10NCHAR(10)
    column12ntext16NCLOB
    column13numeric9NUMBER(18)
    column14nvarchar50NVARCHAR2(50)
    column15real4BINARY_FLOAT
    column16smalldatetime4DATE
    column17smallint2NUMBER(5)
    column18smallmoney4NUMBER(10,4)
    column19sql_variant BLOB
    column20text16CLOB
    column21timestamp8RAW(8)
    column22tinyint1NUMBER(3)
    column23uniqueidentifier16BLOB
    column24varbinary50RAW(50)
    column25varchar50VARCHAR2(50)
    Oracle 10g 转换为SqlServer 2k
    Oracle列名Oracle数据类型SqlServer列名SqlServer数据类型SqlServer数据长度
    COLUMN1BINARY_DOUBLECOLUMN1float8
    COLUMN2BINARY_FLOATCOLUMN2real4
    COLUMN3BLOBCOLUMN3image16
    COLUMN4CLOBCOLUMN4ntext16
    COLUMN5CHAR(10)COLUMN5nchar10
    COLUMN6DATECOLUMN6datetime8
    COLUMN12NUMBERCOLUMN12numeric13
    COLUMN13NVARCHAR2(10)COLUMN13nvarchar10
    COLUMN14RAW(10)COLUMN14varbinary10
    COLUMN15TIMESP(6)COLUMN15datetime8
    COLUMN16TIMESP(6) WITH LOCAL TIME ZONECOLUMN16datetime8
    COLUMN17TIMESP(6) WITH TIME ZONECOLUMN17datetime8
    COLUMN18VARCHAR2(10)COLUMN18nvarchar10
    COLUMN7INTERVAL DAY(2) TO SECOND(6)COLUMN7nvarchar30
    COLUMN8INTERVAL YEAR(2) TO MONTHCOLUMN8nvarchar14
    COLUMN9LONGCOLUMN9ntext16
    COLUMN10LONG RAWCOLUMN10image16
    COLUMN11NCLOBCOLUMN11ntext16
随便看

 

在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板,是学习及工作的有利工具。

 

Copyright © 2002-2024 cuapp.net All Rights Reserved
更新时间:2025/5/28 22:32:12