clob and blob

[ajay verma]

i do not know about character large object as well as binary large object.how these are related with jdbc?

kindly guide me with proper answer!


thanks

[Santhosh Kumar Nunna]

Hai BLOB and CLOB are used for Storing the Large Objects in a Database Table.
BLOB -> Binary Large Object
CLOB -> Character Large Object

You can define any cloumn in a Table as BLOB or CLOB. Only one Column will be allowed as BLOB or CLOB in a Table.

[Swosti Dipan Pal]

Any idea how to display the content of the blob in a jsp. I don't know what is being stored in the blob ?

[Austin Lee]

Originally posted by Swosti Dipan Pal:
Any idea how to display the content of the blob in a jsp. I don't know what is being stored in the blob ?

As I think, the blob is a file stroed in the oracle. For example, image,wav,and Etc.