Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> I'm in confusion of data type definition...
Hello all,
I have a question about the data definition of number data type.
SQL> create table aaa (aaa number(20,5));
Table created.
TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LENGTH DATA_PRECISION
DATA_SCALE
----------------- ---------------------- --------------
------------------ ---------------------- ---------------- AAA AAA NUMBER 22 20 5
SQL> create view bbb as select sum(aaa) sum_aaa from aaa group by aaa;
View created.
TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LENGTH DATA_PRECISION
DATA_SCALE
----------------- ---------------------- --------------
------------------ ---------------------- ---------------- BBB SUM_AAA NUMBER 22
Thanks.
Jimmy
Received on Thu Aug 05 1999 - 00:22:39 CDT