| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> View with no scale / precision on summed number fields
We have many views that sum, avg, etc numeric
values. The data in the tables is defined as number
(9,2) but when the view is created that sums the
amounts, the datatype's scale and precision are
gone... just number is displayed. This forces the
odbc driver to treat the datatype as an integer.
What can be done in the view to force a datatype
of number(9,2)?
David J. Rubin
Data Futures, Inc.
Received on Wed Mar 31 1999 - 21:19:52 CST
 |
 |