Clob Datatype through DB link for more than 10GB data

Clob Datatype through DB link for more than 10GB data

Every value that is manipulated by Oracle Database has its datatype. The datatype of a value links a fixed set of properties with the value. These properties trigger Oracle to treat one value of datatype differently from the values of another. Like for example, you can add the values of NUMBER datatype but not the values of RAW datatype. CLOB is the short term for character large object.

It is a datatype that has single-byte or multi-byte characters. It supports both fixed-width and variable-width character sets and both using the database character set. The maximum size for this datatype is 4 GB – 1. The value of CLOB datatype can be up to 2,147,483,647 characters long. This datatype is used to store Unicode character-based data like huge documents in any character set.

The syntax for the CLOB datatype is: {CLOB |CHARACTER LARGE OBJECT} [ ( length [{K |M |G}] ) ]. The default value of a CLOB datatype if the length is not specified is 2 giga characters (2,147,483,647). The equivalent compile-time Java type for CLOB datatype is java.sql.Clob. The image below is an example.