Re: copy a long from one row to another

Hi, Nicolas. You can use this script as an example:

for rec in (select pdoc from psources where pid = 111) loop

    insert into psources (pid,doc) values (999, rec.pdoc); end loop;

regards

Nicolas DEZAIRE wrote:

> Hello
>
> I'm looking for a method to duplicate a row is should be something like
> that :
>
> insert into psources
> (pid, doc)
> select 999, pdoc
> from psources
> where pid = 111;
>
> where doc is a long.
> Long are a little bit unsual to manage, so what can i do ?
>
> Thanks
>
> Nico
Received on Mon Nov 29 1999 - 09:12:07 CET