1. Could you please tell me the advantages of CLOB over BLOB( i have searched in most of the sites but there is no clear definition except --> CLOB is used to store character data and BLOB is used to store Binary data. Could you please elaborate it)
2. Suppose i have a text file(EDI format) if i store it in CLOB how much space it will take and will it take the same space if stored in BLOB.
3. Will there be any performance improvement in Storing/retreiving a text file in CLOB instead of storing it in a BLOB.