The 12 data types are: 1. Character types include varchar2, nvarchar2, char, nchar and long; 2. Numeric types include number (p, s) and float; 3. Date types include date and timestamp; 4. Other types include blob, clob and bfile.
The operating environment of this tutorial: windows7 system, Dell G3 computer, oracle version 11.2.0.1.0.
1. Character type:
2. Number type:
number (p,s): The maximum precision of p is 38 bits (decimal) p represents the precision, and s represents the number of decimal places to be retained; it can be used to store fixed-length integers and decimals
float: used The precision of storing 126-bit data (binary) is calculated in binary, and the precision range is binary 1~126. When converting to binary, it needs to be multiplied by 0.30103
3. Date type:
date: Used to store date and time, accurate to seconds
timestamp: The date displayed is more accurate than date, accurate to decimal seconds, and can also display morning or afternoon
4. Other data types:
blob: can store up to 4GB of binary data
clob: can store up to 4GB of string data
bfile: The size is related to the operating system. It is used to store unstructured binary data in operating system files outside the database.
Related learning recommendations: oracle database learning tutorial
The above is the detailed content of What are the 12 data types of the database?. For more information, please follow other related articles on the PHP Chinese website!