How to Select a BLOB column

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
prasen120998Asked:
Who is Participating?
 
actonwangCommented:
as this:

  select utl_raw.cast_to_varchar2(blobcol) from table1;

 
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
0
 
prasen120998Author Commented:
I'm using Oracle8.1,
Yes, I want all the data in the Blob field
0
 
prasen120998Author Commented:
I need to check/view the data stored in this field
0
 
actonwangCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.