Oracle Data Type-2

5. Number
Used to store 0, positive, fixed-length negative numbers, and floating-point numbers. The number data type can be in number (P,s)

form to define the precision and range of the numbers. Here: P represents the precision (1-38), which represents the number stored in the column

The total length of the word is P-bit: s represents the range, which represents the number of digits after the decimal point. The value can range from 84 to 127. For example:
CREATE TABLE Test
(Name Number (5))
Use the precision 5来 to define a positive number (such as 12345).
CREATE TABLE Test
(Name Number (5,2))
Use Precision 5 and range to define a number. Numeric values that conform to this data type, such as 123.45 and 12.34

6, LONG
A LONG column stores a variable-length string that can store up to 2GB of data. A LONG column has a number of features in the VARCHAR2 type column. You can use a long column to store a long type of text string. The use of the LONG data type is required for forward compatibility. We recommend that you use LOB data types in place of the LONG type.

7. DATE
Used to store the date and time in the database. The precision of storage time can reach 1/100s. Information about the time zone is not available.
8, TIMESTAMP
Use the year, month, day, hour, minute, and second fields to provide more detailed support for the date/time. You can use up to 9 digits of precision to store the seconds (limited by the underlying operating system support). This data type has no information about the time zone, and it can be used in the Oracle9i database and its updated version.

Oracle Data Type-2