OracleNUMBER

1、一、oracle的number类型精度、刻度范围number(p,s)p:1-38s:-84-127有效数位：从左边第一个不为0的数算起，到末位数字为止的所有数字，小数点和负号不计入有效位数。p0，对s分3种情况：1.s0精确到小数点右边s位，并四舍五入。然后检验有效数位是否createtablet_n(idnumber(5,2);Tablecreated.-小数点前面最多只能有3位，小数点后面位数可以任意多ZWF.YUDONGinsertintot_nvalues(123.45);1rowcreated.ZWF.YUDONGinsertintot_nvalues(123.455);1rowc

2、reated.ZWF.YUDONGinsertintot_nvalues(12.345);1rowcreated.ZWF.YUDONGinsertintot_nvalues(1.234);1rowcreated.ZWF.YUDONGinsertintot_nvalues(.001);1rowcreated.ZWF.YUDONGselect*fromt_n;ID123.45123.4612.351.230.005rowsselected.ZWF.YUDONGinsertintot_nvalues(1234.5678);-有效位为4+25insertintot_nvalues(1234.5678)

3、*ERRORatline1:ORA-01438:valuelargerthanspecifiedprecisionallowedforthiscolumnZWF.YUDONGinsertintot_nvalues(12345);-有效位为5+25insertintot_nvalues(12345)*ERRORatline1:ORA-01438:valuelargerthanspecifiedprecisionallowedforthiscolumn如果sp,小数点右边至少有s-p个0填充。ZWF.YUDONGcreatetablet_n(idnumber(4,5);Tablecreated.Z

4、WF.YUDONGinsertintot_nvalues(1);insertintot_nvalues(1)*ERRORatline1:ORA-01438:valuelargerthanspecifiedprecisionallowedforthiscolumnZWF.YUDONGinsertintot_nvalues(.1);-0.10000，有效位为54insertintot_nvalues(.1)*ERRORatline1:ORA-01438:valuelargerthanspecifiedprecisionallowedforthiscolumnZWF.YUDONGinsertinto

5、t_nvalues(1.01);-1.01000，有效位为64insertintot_nvalues(1.01)*ERRORatline1:ORA-01438:valuelargerthanspecifiedprecisionallowedforthiscolumnZWF.YUDONGinsertintot_nvalues(.01);1rowcreated.ZWF.YUDONGinsertintot_nvalues(.001);1rowcreated.ZWF.YUDONGinsertintot_nvalues(.0001);1rowcreated.ZWF.YUDONGinsertintot_n

6、values(.00001);1rowcreated.ZWF.YUDONGinsertintot_nvalues(.000006);1rowcreated.ZWF.YUDONGinsertintot_nvalues(.0000001);-超过刻度存储01rowcreated.ZWF.YUDONGselect*fromt_n;ID0.010000.001000.000100.000010.000010.000006rowsselected.2.s0精确到小数点左边s位，并四舍五入。然后检验有效数位是否createtablet_n(idnumber(5,-2);Tablecreated.ZWF.Y

7、UDONGinsertintot_nvalues(123);1rowcreated.ZWF.YUDONGinsertintot_nvalues(1234);1rowcreated.ZWF.YUDONGinsertintot_nvalues(12345);1rowcreated.ZWF.YUDONGinsertintot_nvalues(123456);1rowcreated.ZWF.YUDONGinsertintot_nvalues(1234567);1rowcreated.ZWF.YUDONGinsertintot_nvalues(12);1rowcreated.ZWF.YUDONGinse

8、rtintot_nvalues(1);1rowcreated.ZWF.YUDONGinsertintot_nvalues(.1);1rowcreated.ZWF.YUDONGinsertintot_nvalues(1234567.6789);1rowcreated.ZWF.YUDONGselect*fromt_n;ID100120012300123500123460000012346009rowsselected.ZWF.YUDONGinsertintot_nvalues(12345678);insertintot_nvalues(12345678)*ERRORatline1:ORA-01438:valuelargerthanspecifiedprecisionallowedforthiscolumn3.s=0表示整数number