1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
SCOTT@LSC01> create table t1 ( n number);
Table created.
SCOTT@LSC01> create table t2 ( n binary_float);
Table created.
SCOTT@LSC01> insert into t1 select dbms_random.value from emp,emp,emp,emp,emp;
537824 rows created.
SCOTT@LSC01> insert into t2 select dbms_random.value from emp,emp,emp,emp,emp;
537824 rows created.
SCOTT@LSC01> set timi on
SCOTT@LSC01> select avg(n) from t1;
AVG(N)
----------
.499740329
Elapsed: 00:00:00.41
SCOTT@LSC01> select avg(n) from t2;
AVG(N)
----------
4.999E-001
Elapsed: 00:00:00.19 |
Partager