How to display the Data in BLOB column
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.