Search code examples
sqloracle-databasetypesblobvarchar

Oracle BLOB vs VARCHAR

I need to store a (large) SQL query in a column of a table and I thought using a BLOB field. To be clear, I want to store the query, not its result.

What's best to use: BLOB or a VARCHAR? Or something else maybe?

Solution

  • If you're going to store text data that can't fit in a VarChar2 then I think you're supposed to use a CLOB.

    Quote from OraFaq: *A CLOB (Character Large Object) is an Oracle data type that can hold up to 4 GB of data. CLOB's are handy for storing text. *