Xref: alice comp.databases.oracle.misc:47976 comp.databases.oracle.server:75842 comp.databases.oracle.tools:36370
From: "A. Filichkin" <afilich@fors.ru>
Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.server,comp.databases.oracle.misc
Subject: Re: copy a long from one row to another
Date: Mon, 29 Nov 1999 11:12:07 +0300
Organization: FORS
Lines: 29
Message-ID: <38423557.6B13E7F9@fors.ru>
References: <383D2506.92F7535D@theleme.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@news.fors.ru
NNTP-Posting-Date: 29 Nov 1999 08:12:22 GMT
To: Nicolas DEZAIRE <ndezaire@theleme.com>
X-Mailer: Mozilla 4.51 [en] (WinNT; I)
X-Accept-Language: ru,en
X-Trace: 29 Nov 1999 11:29:10 +0300, ns.fors.ru
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newsfeed.gamma.ru!Gamma.RU!news.telekom.ru!news.fors.ru!not-for-mail

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