SQL & PL/SQL

All,

I am not aware of using BFILE datatype. Need your help on this....

I have created one table. Below is the description:

create table test_bfile
(
file_id number,
file_pic bfile)


Then inserted two records in it.

insert into test_bfile values(3,bfilename('C:\','images1.jpg'));

insert into test_bfile values(3,bfilename('C:\','images2.jpg'));

(saved both the JPG files physically in the H/D with the above location)

Its inserted successfully but can't find the way how to retireve those records. bcoz the below statement is not working in this case:

select * from test_bfile;

giving the error 'DATA TYPE IS NOT SUPPORTED'


Can anyone help me out??

Regards
ND