Hi, Today I got a new requirement in Oracle, where I need to access Clob datatypes through DB link. I have not even heard this terminology before. I agreed to take up this project, but I am completely unaware on how to use this, what are its advantages and limitations. Also, I am not authorized to create any type of views in database. Please suggest how to proceed with Clob data type for more than 10 GB of 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.
