Re: Converting from LONG to CLOB

From: TimKArnold <timkarnold_at_aol.com>
Date: 2000/04/08
Message-ID: <20000407212336.18287.00000288@ng-fz1.aol.com>#1/1

If you are using 8i, I believe you can
insert into tab (clob) select to_lob(longfld) from tabx.
Otherwise,
Goto the Thomas Kyte Web site.
You can also use the SQL*PLUS
copy command. It is explained
at the web site.

>Hi
>
>I am trying to convert a field from LONG to CLOB in Oracle8. The
>documentation says that you have to copy LONG to a flat file and then
>load it in the CLOB column using dbms_lob.loadfromfile(). That would
>work for one record but how do I load a number of records of variable
>length?
>
>Thanks
>
>Khurram
>
>
Received on Sat Apr 08 2000 - 00:00:00 CDT