Re: CLOB : Inserting or Updating ?

"Ed" <ed_at_mail.com> schreef in bericht
news:12urm5v9c2sbv0c_at_corp.supernews.com...
> Given a table that has a pk column and a CLOB column, and is to store CLOB
> of 40K ~ 100K
> and you have the option of either Inserting the CLOB or Updating it from
> Null to the CLOB
>
> Which one would you do and why ?
> Thanks
> 10g
>
>
>
>

When you insert a row you have to write a empty clob first to the lob locator and later update your clob column with the actual clob data.

create table mytable(f1 int primary key, f2 clob); insert into mytable(f1, f2) values(1, empty_clob());

regards

Johan Received on Tue Mar 06 2007 - 23:30:58 CST