Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to display the Data in BLOB column

319677Oct 21 2002
Hello All,
I am having a problem that how to display the data of the BLOB column in a table.
by simple select statement it just give me that result.

Table FILEDATA has only two columns:
ID number,
DATA BLOB

Select * from FILEDATA;

ID DATA
1 (BLOB)
2 (BLOB)
3 (BLOB)

Now i want to get the actual string that i have inserted in the DATA(BLOB) column.

Is there any way in SQL Or PL/SQL though which i can get the data in the string format.

Kindly give me the code that will solve the reqired problem.

Thanks in Advance,
Regards,
Omer.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2002
Added on Oct 21 2002
2 comments
1,612 views