drop table t_lob purge;
Таблица удалена.
create table t_lob(f1 clob);
Таблица создана.
insert into t_lob(f1) values(null);
1 строка создана.
declare
l_clob1 clob;
l_clob2 clob;
l_string varchar2(20):= '[Hello World]';
begin
update t_lob set f1 = empty_clob() returning f1 into l_clob1;
l_clob2 := l_clob1;
dbms_output.put_line('1 = ' || dbms_lob.istemporary(l_clob1));
dbms_output.put_line('2 = ' || dbms_lob.istemporary(l_clob2));
dbms_lob.writeappend(l_clob1, length(l_string), l_string);
dbms_lob.writeappend(l_clob2, length(l_string), l_string);
dbms_lob.writeappend(l_clob1, length(l_string), l_string);
dbms_lob.writeappend(l_clob2, length(l_string), l_string);
dbms_output.put_line('1 = ' || l_clob1);
dbms_output.put_line('2 = ' || l_clob2);
end;
/
1 = 0
2 = 0
1 = [Hello World][Hello World][Hello World]
2 = [Hello World][Hello World][Hello World][Hello World]
Процедура PL/SQL успешно завершена.
select dbms_lob.substr(f1, 60) from t_lob;
DBMS_LOB.SUBSTR(F1,60)
------------------------------------------------------------------
[Hello World][Hello World][Hello World][Hello World] |