BLOB query

Hi Guys,
I have a table which contains a BLOB type as field. I have queried
the same table using select statement i got the following error.

Inconsistent Data type.
Could any one tell me the query for getting the value of this BLOB field.

Regards,
Sudheer

refer to dbms_lob package

Query with SQLPLUS, if that was the case you must be kidding!

How do you expect SQLPLUS shows you BLOB...

Hi,

try using the DBMS_LOB_READ package might take you nearest to the reading the data from database.

VAST