oracle类型介绍,oracle 数据类型介绍

ORACLEbigint   8                               NUMBER(19)

binary   50                              RAW(50)

bit      1                                  NUMBER(2)

char     10                                CHAR(10)

datetime 8                             DATE

decimal  9                              NUMBER(18)

float    8                                BINARY_DOUBLE

image    16                               BLOB

int      4                                  NUMBER(10)

money    8                                NUMBER(19,4)

nchar    10                               NCHAR(10)

ntext    16                               NCLOB

numeric  9                              NUMBER(18)

nvarchar 50                            NVARCHAR2(50)

real     4                                 BINARY_FLOAT

smalldatetime 4                        DATE

smallint  2                             NUMBER(5)

smallmoney    4                           NUMBER(10,4)

sql_variant                           BLOB

text      16                                CLOB

timestamp 8                            RAW(8)

tinyint    1                              NUMBER(3)

uniqueidentifier  16                    BLOB

varbinary  50                           RAW(50)

varchar    50                             VARCHAR2(50)