oracle的表都存放在,Oracle保存图片到表

..

2007-08-13 16:19 1,212,681 flower.jpg

1 File(s) 1,212,681 bytes

2 Dir(s) 40,406,614,016 bytes free

----------------------------------------------------

SQL> conn a/a

Connected.

grant create any directory to a;

grant create any library to a;

create or replace directory photo_dir as 'e:photo';

create table photos (blob_column blob);

declare

a_blob blob;

a_bfile bfile := bfilename('PHOTO_DIR','flower.jpg');

begin

insert into photos values (empty_blob()) returning blob_column into a_blob;

dbms_lob.fileopen(a_bfile);

dbms_lob.loadfromfile(a_blob,a_bfile,dbms_lob.getlength(a_bfile));

dbms_lob.fileclose(a_bfile);

commit;

end;

/

PL/SQL procedure successfully completed.

SQL> select dbms_lob.getlength(blob_column) from photos;

DBMS_LOB.GETLENGTH(BLOB_COLUMN)

-------------------------------

1212681[@more@]保存