Re: How to: Copy LONG field from one table to another

Used a PL-SQL procedure. Works fine.

I think SQL*Plus COPY ... SELECT would also work since it generates an anonymous PL-SQL block to do the jobs....

Marc Mazerolle
InforMaze Technologies.

Ken Rachynski wrote:

> Good day,
>
> I have two identical tables that I would like to make have the same
> data. I recall from school that one cannot create a table based on
> another table (CREATE...AS...) where the source table contains a LONG
> field. As a result, I tried to insert data in the second table using a
> sub query (INSERT...SELECT...) and discovered that I can't do that
> either.
>
> How do I get the contents of one LONG field into an identical field in
> another table?
>
> --
> Ken Rachynski
> Database Analyst
> krachyn_at_cadvision.com
> <http://www.cadvision.com/krachyn>
> ICQ: 3113514
Received on Wed Feb 03 1999 - 09:52:12 CST