CLOB and BLOB are two types of data types used in databases to store large amounts of data.
BLOB: BLOB, or Binary Large Object, is used to store binary data such as images, audio, video, and other multimedia objects. It is an extension of the VARBINARY data type and can store up to 2GB of data.Using CLOB and BLOB data types can be beneficial in many situations.
CLOB:CLOB, or Character Large Object, is used to store textual data and is used for large strings of text. It is an extension of the VARCHAR data type and can store up to 4GB of data
if you have a large document or image you need to store, you can use a CLOB or BLOB data type to store it.storage space is occupied more in the database, so you should be careful about when and how you use them.
To query for CLOB or BLOB datatypes,
select owner,table_name,SEGMENT_NAME,TABLESPACE_NAME from dba_lobs where OWNER='OWNER_NAME'; select owner,segment_name,segment_type,bytes/1024/1024 as MB from dba_segments where segment_name='SYS_03$$'
;
CLOB and BLOB column will not be calculated when querying size of table,
Recent Posts
