Home  >  Article  >  Database  >  What are the 12 data types of the database?

What are the 12 data types of the database?

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-05-06 17:36:1552439browse

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.

What are the 12 data types of the database?

The operating environment of this tutorial: windows7 system, Dell G3 computer, oracle version 11.2.0.1.0.

1. Character type:

What are the 12 data types of the database?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn