社区 › Oracle数据库开发 › ORACLE与非结构化数据

botang 发表于 2020-9-20 15:05:10

ORACLE与非结构化数据

select* from dba_directories;

select* from dba_tab_privstp where tp.grantee='HR';

create table t071fi11_blob ( pic#number(2),   pic_namevarchar2(20),   photoblob ) ;

CREATE OR REPLACE PROCEDUREproc071fi11_blob (p_1 number, p_2 varchar2,p_dirVARCHAR2, p_fileVARCHAR2)
IS
   v_fBFILE;
   v_b blob;
BEGIN
    INSERT INTO t071fi11_blob values(p_1,   p_2,   EMPTY_BLOB ()) RETURN   photo    into v_b;
    v_f := BFILENAME (p_dir, p_file);
   DBMS_LOB.FILEOPEN(v_f, DBMS_LOB.FILE_READONLY);
   DBMS_LOB.LOADFROMFILE (v_b, v_f,   DBMS_LOB.GETLENGTH (v_f));
   DBMS_LOB.FILECLOSE (v_f);
   commit;
end;
/

begin
   proc071fi11_blob(1, 'RedHat is good', 'DIR1', 'c.jpg');
end;
/

select* from t071fi11_blob;
   

查看完整版本: ORACLE与非结构化数据