Current location - Loan Platform Complete Network - Big data management - What fields are used in Oracle database?
What fields are used in Oracle database?

In Oracle, if the field is too large, blob or clob is generally used. The relevant explanations are as follows:

1. BLOB

BLOB stands for Binary Large Object. ). It is used to store large binary objects in databases. The maximum size that can be stored is 4G bytes

2. CLOB

CLOB stands for Character Large Object. It is similar to the LONG data type, except that CLOB is used to store large single-byte character data blocks in the database and does not support character sets with varying widths.

The maximum size that can be stored is 4G bytes