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.
1 Answer
This oracle package will do the job
select dbms_lob.substr(b,2000,1) from blobtest;