What are the data types supported by Oracle database?

Oracle database provides diverse data types, including: numeric types: INTEGER, FLOAT, DOUBLE PRECISION, NUMBER, DEC text types: CHAR, VARCHAR2, CLOB, NCLOB date and time types: DATE, TIME, TIMESTAMP, INTERVAL Boolean value type: BOOLEAN Binary type: BLOB, BFILE

Data types supported by Oracle database

Oracle database Various data types are provided to store different types of data, including numbers, text, dates and times, Boolean values, and binary data.

Number type

• INTEGER: Integer, including positive and negative numbers.
• FLOAT: Floating point number, representing a number with a decimal part.
• DOUBLE PRECISION: Double precision floating point number with higher precision and range.
• NUMBER: An exact numeric value with the specified precision and range.
• DEC: Decimal number, used for applications requiring precise rounding and calculations.

Text Type

• CHAR: Fixed-length character string padded with spaces within the maximum allocated length.
• VARCHAR2: Variable length character string, the length required to store the actual data.
• CLOB: Large text object that can store large amounts of character data (up to 4 GB).
• NCLOB: National character large text object used to store Unicode character data.

Date and time types

• DATE: Represents the date, including year, month and day.
• TIME: Represents time, including hours, minutes, and seconds.
• TIMESTAMP: Represents the date and time, including the timestamp (millisecond part).
• INTERVAL: Represents a time interval, which can represent the difference between years, months, days, hours, minutes, and seconds.

Boolean value type

• BOOLEAN: A Boolean value type that can only store true or false values.

Binary type

• BLOB: Binary large object that can store binary data (up to 4 GB).
• BFILE: Binary file used to point to binary data stored in an external file.

By providing these rich data types, Oracle Database ensures that various data types can be effectively stored and managed to meet the needs of different applications and industries.

The above is the detailed content of What are the data types supported by Oracle database?. For more information, please follow other related articles on the PHP Chinese website!