Oracle data type-2, oracle-2
5. NUMBER
It is used to store zero, positive, fixed-length negative, and floating point numbers. The NUMBER data type can be set to NUMBER (P, S)
Format to define the precision and range of numbers. Here: p indicates the precision (1-38), which indicates the number stored in the column
The total length of a word is p bit: s indicates the range, which indicates the number of digits after the decimal point. The value range is-84 to 127. For example:
Create table test
(Name number (5 ))
Use precision 5 to define a positive number (for example, 12345 ).
Create table test
(Name number (5, 2 ))
Define a number using precision 5 and range 2. Numeric values that match this data type, such as 123.45 and 12.34
6. LONG
LONG Columns store variable-length strings and can store up to 2 GB of data. LONG columns have many features in VARCHAR2 columns. LONG columns can be used to store LONG text strings. The LONG data type is used for forward compatibility. We recommend that you use the LOB data type instead of the LONG type.
7. DATE
It is used to store the date and time in the database. The storage time precision can reach 1/100 s. Time zone information is not provided.
8. TIMESTAMP
Use the year, month, day, hour, minute, and second fields to provide more detailed support for the date/time. A maximum of nine digits can be used for second storage (limited by the underlying operating system ). This data type does not have time zone information. It can be used in the Oracle9i database and its latest version.