sqlldrdbms_lob都可以办到的
grant create any directory to scott;
grant create any library to scott;create or replace directory utllobdir as 'G:\oracle';
-- select * from ALL_DIRECTORIES;create table bfile_tab (bfile_column BFILE);
create table utl_lob_test (blob_column BLOB);set serveroutput on然后执行下面语句就将G:\oracle目录下的Azul.jpg存入到utl_lob_test
表中的blob_column字段中了。
declare
a_blob BLOB;
a_bfile BFILE := BFILENAME('UTLLOBDIR','Azul.jpg');
begin
insert into bfile_tab values (a_bfile) -- BFILE
returning bfile_column into a_bfile; insert into utl_lob_test values (empty_blob()) -- 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;
/
select dbms_lob.getlength(blob_column) from UTL_LOB_TEST;lob 到对象列create table image_load( id number, name varchar2(255),
image ordsys.ordimage )
/desc ordsys.ordimagedesc ordsys.ordsourceLOAD DATA
INFILE *
INTO TABLE T
replace
fields terminated by ","
(
id,
name,
fiel_name filler,
image column object
(
source column object
(
localdatalobfile(file_name) terminated by bof
nullif file_name='NONE'
)
)
)
begindata
1,icons,icons.gif
grant create any directory to scott;
grant create any library to scott;create or replace directory utllobdir as 'G:\oracle';
-- select * from ALL_DIRECTORIES;create table bfile_tab (bfile_column BFILE);
create table utl_lob_test (blob_column BLOB);set serveroutput on然后执行下面语句就将G:\oracle目录下的Azul.jpg存入到utl_lob_test
表中的blob_column字段中了。
declare
a_blob BLOB;
a_bfile BFILE := BFILENAME('UTLLOBDIR','Azul.jpg');
begin
insert into bfile_tab values (a_bfile) -- BFILE
returning bfile_column into a_bfile; insert into utl_lob_test values (empty_blob()) -- 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;
/
select dbms_lob.getlength(blob_column) from UTL_LOB_TEST;lob 到对象列create table image_load( id number, name varchar2(255),
image ordsys.ordimage )
/desc ordsys.ordimagedesc ordsys.ordsourceLOAD DATA
INFILE *
INTO TABLE T
replace
fields terminated by ","
(
id,
name,
fiel_name filler,
image column object
(
source column object
(
localdatalobfile(file_name) terminated by bof
nullif file_name='NONE'
)
)
)
begindata
1,icons,icons.gif
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货