How do you copy "long" data from one table to another?

1. How do you write a PL/SQL procedure which copies data from one "long" column in a table to another "long" column in another table.

Something which would have the same effect as:

update to_table
set to_long_column =

   (select from_long_column
    from   from_table
    where  from_keyname = from_key)

if Oracle allowed "long" columns to be selected in sub-queries.

2. Can that procedure take the names of the tables and columns as arguments?

Thanks for any suggestions,

Anil Received on Thu Jul 06 1995 - 00:00:00 CEST