axdlz,oracle是否有整数类型? 这种类型的最大值是多少?
Integer是Number类型的子类型。
NUMBERType
ousethenumberdatatypetostorefixedorfloatingpointnumbers
ofvirtuallyanysize.youcanspecifyprecision,whichisthetotal
numberofdigits,andscale,whichdetermineswhereroundingoccurs。
Thesyntaxfollows:
number[(precision,scale ) ]
(oucannotuseconstantsorvariablestospecifyprecisionandscale;
youmustuseintegerliterals.themaximumprecisionofanumbervalue
is38; themagnituderangeis 1.0 e-129 . 9.99 e125.if you do not
specifytheprecision,itdefaultstothemaximumvaluesupportedby
yoursystem
scalecanrangefrom-84to 127.for instance,ascaleof2roundsto
thenearesthundredth (3.456 becomes 3.46 ).Scalecanbenegative、
wichcausesroundingtotheleftofthedecimalpoint.for example、
ascaleof-3 roundstothenearestthousand (3456 becomes 3000 ).a
saleofzeroroundstothenearestwholenumber.ifyoudonotspecify
thescale,itdefaultstozero。
thenumbersubtypesbelowhavethesamerangeofvaluesastheirbase
type.Forexample,floatisjustanothernamefornumber。
缉毒局
最差
双精度
浮动
智能手机
输入
数字
真实
苏默林
oucanusethesesubtypesforcompatibilityorwhenyouwantan
身份描述符thannumber。
转载于:https://www.cn blogs.com/arxive/p/6093050.html