SQL - Character large object (CLOB)

About

A Character large object (CLOB) is a SQL data type used to store a large amount of character data.

It's a specialized variant of large object (LOB) where data is stored in a file on the local file system with a text mime. The database would then decode the binary into a text and send it to you.

Analytics

You would not use any clob column in any group by or window/aggregation function to perform any analtyics.

You would mostly retrieve the content and process it with a third application.