Application Domain#

NUMBERn is an application domain with the following characteristics:

• Stored in the Data base as a Numeric field with a length of n
• Displayed to the user as a numeric field

Oracle Data Type#

NUMBER(nn,xx) is an 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).

---

Notes #

Click to create a new notes page