This page (revision-4) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by Administrator

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 1016 bytes rforbes to previous
3 26-Nov-2021 10:22 318 bytes RForbes to previous | to last
2 26-Nov-2021 10:22 185 bytes Administrator to previous | to last
1 26-Nov-2021 10:22 193 bytes Administrator to last

Page References

Incoming links Outgoing links
NUMBE Rn

Version management

Difference between version and

At line 1 removed 2 lines
!Application Domain
At line 8 removed one line
!Oracle Data Type
At line 10 removed 5 lines
NUMBER(nn,xx) is an [Oracle data type|ORACLE DATA TYPE] that identifies the field in the data base as holding numeric-only values with a variable length not to exceed the number of digits indicated in the first field (nn). If the optional second number (,xx) is also provided, then the field may hold a number of digits to the right of the decimal.
For example, a field defined as NUMBER(10) (or NUMBER(10,0)) may hold a value which has as many as ten digits, with no decimal values (i.e. 9,876,543,210) and a field defined as NUMBER(18,6) may hold a value of 18 digits, 6 of which are to the right of the decimal (i.e. 987,654,321,012.123456).