Re: Inserting long columns

From: Andy Klock <andy_at_oracledepot.com>
Date: Thu, 27 Jun 2013 13:17:38 -0400
Message-ID: <CADo_RaO0ziXYqjss-p2z4RN-YzSW08RjsdC5XbBzfyySBLgBnA_at_mail.gmail.com>

Or use straight SQL via the TO_LOB function. So if you are merging it into a CLOB then that should work. LONGs are so last millennium. http://docs.oracle.com/cd/E11882_01/server.112/e17118/functions205.htm

On Thu, Jun 27, 2013 at 12:44 PM, David Fitzjarrell <oratune_at_yahoo.com>wrote:

> +It really depends on how long the LONG data is; if it's less than 32K you
> can write a PL/SQL block to populate a varchar2 variable and merge the data
> that way:
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 27 2013 - 19:17:38 CEST