Difference between CLOB and CLOB data type in Oracle







Difference between CLOB and CLOB 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

No comments:

Post a Comment