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 >
|
BLOB data type is appropriate for storing following >
|
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