APPEND

向目标LOB尾部追加数据

声明

DBMS_LOB.APPEND (
  dest_lob IN OUT  NOCOPY BLOB,
  src_lob  IN             BLOB);

DBMS_LOB.APPEND (
  dest_lob IN OUT  NOCOPY CLOB  ,
  src_lob  IN             CLOB );

结构

参数	说明
dest_lob	目的定位器
src_lob	源定位器

示例

    
drop table tLob cascade;
    
Create Table tLob (
    no Number(4),
    name VarChar2(10),
    resume CLob,
    photo BLob,
    record BFile
    );
insert into tLob values(1,'Nick','CLOB对象列',empty_blob(),bfilename('MYDIR','1.JPG'));
   
insert into tLob values(2,'Jack','CLOB对象列',empty_blob(),bfilename('MYDIR','2.JPG'));
   
insert into tLob values(3,'Mary','对象列CLOB',empty_blob(),bfilename('MYDIR','3.JPG'));
 
create or replace procedure test_append()

as
  
Declare
    varC clob;
    vAStr varchar2(1000);
Begin
    vAStr := '，这是大对象列';
    select resume into varC from tlob where no = 1 FOR UPDATE;
    DBMS_LOB.Append(varC, vAStr);
    commit;
    DBMS_output.put_line('追加结果为: '||varC);
End; 


/
exec test_append();
/