The core of the Oracle database is the table, with the following common data types used by the columns in the table:
CHAR (length)
Stores a fixed-length string. The length of the parameter is specified, and is padded with spaces if the stored string is less than length.
The default length is 1 and the maximum is 2000 bytes.
VARCHAR2 (length)
Stores variable-length strings. length specifies the maximum size of the string. The default length is 1 and is no longer than 4000 characters.
Number (P,s)
You can store either floating-point numbers or integers, and p represents the maximum number of digits (in the case of decimals including integral and fractional parts).
And the decimal point, P is 38 by default, and S refers to the number of decimal places.
DATE
Stores the date and time, storage era, 4-bit year, month, day, hour, minute, and second.
TIMESTAMP
Not only the date of the month day, the time division seconds, and the second after 6 bits, and also contains the timezone.
Clob
Storing large text, such as storing unstructured XML documents
Blob
Store binary objects, shapes, videos, sounds, and more.
Example:
The actual storage of the digital format input
Number 1234.567 1234.567
Number (6,2) 123.4567 123.46
Number (4,2) 12345.67 has entered more than the specified precision, the database cannot be stored
Oracle data types