没有varchar()这个类型。number(m,n)表示定点数
To declare fixed-point numbers, for which you must specify scale, use the following
form:
NUMBER(precision,scale)number(m)表示整数
To declare integers, which have no decimal point, use this form:
NUMBER( precision) -- same as NUMBER( precision,0)decimal(m,n)是number的子类型
You can use the following NUMBER subtypes for compatibility with ANSI/ISO and IBM types or when you want a more descriptive name:DEC
DECIMAL
DOUBLE PRECISION
FLOAT
INTEGER
INT
NUMERIC
REAL
SMALLINTUse the subtypes DEC, DECIMAL, and NUMERIC to declare fixed-point numbers with
a maximum precision of 38 decimal digits.
To declare fixed-point numbers, for which you must specify scale, use the following
form:
NUMBER(precision,scale)number(m)表示整数
To declare integers, which have no decimal point, use this form:
NUMBER( precision) -- same as NUMBER( precision,0)decimal(m,n)是number的子类型
You can use the following NUMBER subtypes for compatibility with ANSI/ISO and IBM types or when you want a more descriptive name:DEC
DECIMAL
DOUBLE PRECISION
FLOAT
INTEGER
INT
NUMERIC
REAL
SMALLINTUse the subtypes DEC, DECIMAL, and NUMERIC to declare fixed-point numbers with
a maximum precision of 38 decimal digits.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货