for b in (select * from tab_b where ...) loop
insert into tab_a (x, y, z) values ( b.x, b.y, b.z );
end loop;
commit;
I would recommend changing LONGs to LOBs though - LOBs are
much more flexible and efficient than LONGs.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Stephan Bressler" <stephan.bressler_at_pdb.sbs.de> wrote in message
news:ab5ekf$oj7$1_at_news.mch.sbs.de...
> Hi,
>
> I need to do something like
> insert into tab_a select * from tab_b where ...
>
> Unfortunately, both tables contain a column of type 'long'.
>
> Is there a short workaround, e.g. PL/SQL?
>
> TIA
> Stephan
>
>
Received on Mon May 06 2002 - 08:25:42 CDT
