Read Oracle BLOB type via SQL I have an oracle table with field type BLOB, length 4000, data type "2004".
I know that this field simply contains some XML.  How can I read the value of the BLOB, using an SQL select statement?  Is there some conversion function to use?
The same table/field in Sql Server is simply text.
This oracle package will do the job

select dbms_lob.substr(b,2000,1) from blobtest;