Re: Oracle 8.0 Copy long from 1 table to another

On Wed, 01 Oct 2003 16:27:25 GMT, jcwhui <j_c_w_h_u_i_at_hot_mail.company> wrote:

>I doubt this will work for me. My code is inside a stored procedure. And
>in fact I meant to copy 1 particular row from table_b to table_a, i.e.
>"insert into table_a select long_column from table_b where id=123"
>
>I guess external file access is my only option now. Thanks anyway!

Use dbms_sql. dbms_sql can be used to copy chunks of your longs. Examples IIRC on the site of Thomas Kyte

--
Sybrand Bakker, Senior Oracle DBA