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 >
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- 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