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

JDBC connection with Oracle 11g - ojdbc6.jar - configure java build path - registering driver - getConnection - Writing your First jdbc program

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

Labels: Core Java JDBC Oracle