Re: [SQL] How to merge two tables into one ?

Lothar Armbrüster wrote:
> begin
> for comm_rec in comm_cur loop
> update policynew
> set comment=comment||comm_rec.comment||chr(10)
> where
> id=comm_rec.id;
> end loop;
> end;

OK, this worked perfectly, but I still have a litte problem : Let's assume that the Comment fiel in the PolicyNew table is of type "Long", and the "Comment" field in the Commentary table are of type varchar2(X).

When I try to concatenate, I have an error message. Is there a way to do it ?

TIA, Zahi

--
Zahi Al-Jamous e-mail: aljamous_at_crv.pechiney.fr Groupe GIL
Pechiney-CRV

BP 27				tel (work): +33.(0)4.76.57.82.45
F-38340 Voreppe			tel (cell): +33.(0)6.14.55.16.88