Re: Inserting long columns

From: Denise Gwinn <denise_at_mail.wvnet.edu>
Date: Thu, 27 Jun 2013 12:41:31 -0400
Message-ID: <51CC6B3B.6030402_at_mail.wvnet.edu>

It is Oracle 11.2.0.2.
Here is a description of the table:

SQL> DESC GUBBHLP

  Name                                            Null?    Type
  ----------------------------------------------- -------- 
--------------------------------
  GUBBHLP_FORM_NAME                               NOT NULL VARCHAR2(30)
  GUBBHLP_BLOCK_NAME VARCHAR2(30)
  GUBBHLP_FIELD_NAME VARCHAR2(30)
  GUBBHLP_TEXT                                    NOT NULL LONG
  GUBBHLP_ACTIVITY_DATE                           NOT NULL DATE

On 6/27/2013 12:30 PM, Don Seiler wrote:
> Can you provide the version of Oracle DB and perhaps a DESC or CREATE
> TABLE for the tables involved? It would make it much easier to provide
> some thoughts or help.
>
>
> On Thu, Jun 27, 2013 at 11:09 AM, Denise Gwinn <denise_at_mail.wvnet.edu
> <mailto:denise_at_mail.wvnet.edu>> wrote:
>
> I have to merge some tables that contain a long datatype. A simple
> insert into tableA (select * from tableB) will not work. I've tried
> Googling, but not having much success. Could someone enlighten me
> please?
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
> --
> Don Seiler
> http://www.seiler.us

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

Received on Thu Jun 27 2013 - 18:41:31 CEST