极限值的研究
insert into demo(id) values( 9.9999999000000000000000000009912345678912*power(10,125) );
insert into demo(id) values( 9.9999999000000000000000000009912345678912*power(10,124) );
insert into demo(id) values( 9.9999999000000000000000000009912345678912*power(10,123) );
insert into demo(id) values( 9.9999999000000000000000000009912345678912*power(10,122) );
insert into demo(id) values( 9.9999999000000000000000000009912345678912*power(10,121) );
insert into demo(id) values( 9.9999999000000000000000000009912345678912*power(10,-121));
insert into demo(id) values( 9.9999999000000000000000000009912345678912*power(10,-122));
insert into demo(id) values( 9.9999999000000000000000000009912345678912*power(10,-123));
insert into demo(id) values( 9.9999999000000000000000000009912345678912*power(10,-128));
极限值的研究
========================
insert into demo(id) values( 9.9999999000000000000000000009912345678912*power(10,-130));
insert into demo(id) values(-9.9999999000000000000000000009912345678912*power(10,125));
insert into demo(id) values(-9.9999999000000000000000000009912345678912*power(10,124));
insert into demo(id) values(-9.9999999000000000000000000009912345678912*power(10,123));
insert into demo(id) values(-9.9999999000000000000000000009912345678912*power(10,122));
insert into demo(id) values(-9.9999999000000000000000000009912345678912*power(10,121));
insert into demo(id) values(-9.9999999000000000000000000009912345678912*power(10,-121));
insert into demo(id) values(-9.9999999000000000000000000009912345678912*power(10,-122));
insert into demo(id) values(-9.9999999000000000000000000009912345678912*power(10,-123));
insert into demo(id) values(-9.9999999000000000000000000009912345678912*power(10,-128));
insert into demo(id) values(-9.9999999000000000000000000009912345678912*power(10,-130));
SQL>col id for 9.999999999999999999999999999999999999999EEEE
SQL> select vsize(id) sz,id from demo;
quer_result
query_result
SZ ID
--- -----------------------------------------------
21 9.999999900000000000000000000991234567890E+125
21 9.999999900000000000000000000991234567890E+124
21 9.999999900000000000000000000991234567890E+123
21 9.999999900000000000000000000991234567890E+122
21 9.999999900000000000000000000991234567890E+121
21 9.999999900000000000000000000991234567890E-121
21 9.999999900000000000000000000991234567890E-122
21 9.999999900000000000000000000991234567890E-123
21 9.999999900000000000000000000991234567890E-128
21 9.999999900000000000000000000991234567890E-130
21 -9.999999900000000000000000000991234567890E+125
21 -9.999999900000000000000000000991234567890E+124
21 -9.999999900000000000000000000991234567890E+123
21 -9.999999900000000000000000000991234567890E+122
21 -9.999999900000000000000000000991234567890E+121
21 -9.999999900000000000000000000991234567890E-121
21 -9.999999900000000000000000000991234567890E-122
21 -9.999999900000000000000000000991234567890E-123
21 -9.999999900000000000000000000991234567890E-128
21 -9.999999900000000000000000000991234567890E-130
看它们的内部结构为:
SQL>select dump(id,16) xdump from demo
XDUMP
--------------------------------------------------------------------------------------------
Typ=2 Len=21: ff,64,64,64,64,1,1,1,1,1,1,1,1,1,1,64,d,23,39,4f,5b
Typ=2 Len=21: ff,a,64,64,64,5b,1,1,1,1,1,1,1,1,1,a,5c,18,2e,44,5a
Typ=2 Len=21: fe,64,64,64,64,1,1,1,1,1,1,1,1,1,1,64,d,23,39,4f,5b
Typ=2 Len=21: fe,a,64,64,64,5b,1,1,1,1,1,1,1,1,1,a,5c,18,2e,44,5a
Typ=2 Len=21: fd,64,64,64,64,1,1,1,1,1,1,1,1,1,1,64,d,23,39,4f,5b
Typ=2 Len=21: 84,64,64,64,64,1,1,1,1,1,1,1,1,1,1,64,d,23,39,4f,5b
Typ=2 Len=21: 84,a,64,64,64,5b,1,1,1,1,1,1,1,1,1,a,5c,18,2e,44,5a
Typ=2 Len=21: 83,64,64,64,64,1,1,1,1,1,1,1,1,1,1,64,d,23,39,4f,5b
Typ=2 Len=21: 81,a,64,64,64,5b,1,1,1,1,1,1,1,1,1,a,5c,18,2e,44,5a
Typ=2 Len=21: 80,a,64,64,64,5b,1,1,1,1,1,1,1,1,1,a,5c,18,2e,44,5a
Typ=2 Len=21: 0,2,2,2,2,65,65,65,65,65,65,65,65,65,65,2,59,43,2d,17,b
Typ=2 Len=21: 0,5c,2,2,2,b,65,65,65,65,65,65,65,65,65,5c,a,4e,38,22,c
Typ=2 Len=21: 1,2,2,2,2,65,65,65,65,65,65,65,65,65,65,2,59,43,2d,17,b
Typ=2 Len=21: 1,5c,2,2,2,b,65,65,65,65,65,65,65,65,65,5c,a,4e,38,22,c
Typ=2 Len=21: 2,2,2,2,2,65,65,65,65,65,65,65,65,65,65,2,59,43,2d,17,b
Typ=2 Len=21: 7b,2,2,2,2,65,65,65,65,65,65,65,65,65,65,2,59,43,2d,17,b
Typ=2 Len=21: 7b,5c,2,2,2,b,65,65,65,65,65,65,65,65,65,5c,a,4e,38,22,c
Typ=2 Len=21: 7c,2,2,2,2,65,65,65,65,65,65,65,65,65,65,2,59,43,2d,17,b
Typ=2 Len=21: 7e,5c,2,2,2,b,65,65,65,65,65,65,65,65,65,5c,a,4e,38,22,c
Typ=2 Len=21: 7f,5c,2,2,2,b,65,65,65,65,65,65,65,65,65,5c,a,4e,38,22,c |