Introduction to several big object data types in oracle databases, oracle Data Types

Introduction to several big object data types in oracle databases, oracle Data Types

We know that in oracle databases, the maximum length of the field type that can store character-type data type varchar2 is 4000. In actual business, we often encounter ultra-long data or special format data, such as text and image data. Let's take a look at several common big object data types, field data types can be accurately located during physical model design. The following are common big object data types:

BLOB: binary data with no structure can be stored, up to 4 GB of online data can be stored.

CLOB: stores single-byte character data, up to 4 GB

NLOB

BFILE: External binary files can be stored.

BLOB, CLOB, and NCLOB can both store large image files or non-text files, such as formatted text files, audios, and videos.