Difference between CLOB and BLOB data type in Oracle






Difference between CLOB and BLOB data type in Oracle >




CLOB data type
BLOB data type
CLOB stands for Character Large Object.
BLOB stands for Binary Large Object.
CLOB stores values in character streams.
BLOB stores values in bitstreams.
CLOB is used for storing single-byte character data (Character string made up of single-byte character data)
BLOB is used for storing binary data.
CLOB data type is appropriate for storing text information. Example >
  • text files,
  • pdf,
  • doc,
  • docx and
  • odf formats.
BLOB data type is appropriate for storing following >
  • image,
  • graphical,
  • voice and
  • some application specific data.


RELATED LINKS>


Oracle 11g and SQL Developer installation and setup on 32/64bit windows - explained step by step with screenshots





java.sql.PreparedStatement - using executeUpdate  and executeQuery methods - CREATE, SELECT, INSERT, UPDATE and DELETE


JDBC- Insert/Store/save FILE in database

JDBC- Batch PreparedStatement example- Execute INSERT query(DML command) using PreparedStatement's addBatch() and executeBatch() methods in java



Execute database STORED PROCEDURE - IN parameter, OUT parameter and IN OUT parameter || call FUNCTION from java


Must read : IMAGE - Storing in and retrieving out from database
FILE - Storing in and retrieving out from database

eEdit
Must read for you :