<div>
what programming language?<br />
what do you want to do with the data?<br />
do you need all the data?<br />
<br />
<a href="http://www.codeproject.com/useritems/Blobfield.asp" rel="ugc">http://www.codeproject.com/useritems/Blobfield.asp</a>
</div>


what programming language?
what do you want to do with the data?
do you need all the data?

http://www.codeproject.com/useritems/Blobfield.asp [http://www.codeproject.com/useritems/Blobfield.asp]

<div>
I'm using Oracle8.1, <br />
Yes, I want all the data in the Blob field
</div>


I'm using Oracle8.1,
Yes, I want all the data in the Blob field

<div>
I need to check/view the data stored in this field
</div>


I need to check/view the data stored in this field

<div>
what information is in that blob? pure text or some binary information? how big is it?<br />
<br />
If it contains text information, you can still view or check them through simple sql by using: UTL_RAW.CAST_TO_VARCHAR2(&lt;<wbr />blob column&gt;)<br />
<br />
<br />
Acton
</div>


what information is in that blob? pure text or some binary information? how big is it?

If it contains text information, you can still view or check them through simple sql by using: UTL_RAW.CAST_TO_VARCHAR2(<blob column>)


Acton

<div>
<div class="content wysiwyg-content">
I've a table which has a BLOB column, I wanted to Select the data in the BLOB field, how do I do this. Normal select query doesn't help in this case<br />
<br />
rgds<br />
prasen
</div>
</div>


I've a table which has a BLOB column, I wanted to Select the data in the BLOB field, how do I do this. Normal select query doesn't help in this case

rgds
prasen

How to Select a BLOB column

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.