Re: Inserting long columns
From: ~Jeff~ <jifjif_at_gmail.com>
Date: Fri, 28 Jun 2013 11:45:01 +1200
Message-ID: <CANz7uMYy=t95SpwQScAK4YHSUPonOxLX=R_0hW5_Lr9qP+DnMQ_at_mail.gmail.com>
Hi Denise,
the COPY TABLE syntax works for LONG
datatypes.<http://docs.oracle.com/cd/B10500_01/server.920/a90842/apb.htm> http://docs.oracle.com/cd/E11882_01/server.112/e16604/apb.htm
Date: Fri, 28 Jun 2013 11:45:01 +1200
Message-ID: <CANz7uMYy=t95SpwQScAK4YHSUPonOxLX=R_0hW5_Lr9qP+DnMQ_at_mail.gmail.com>
Hi Denise,
the COPY TABLE syntax works for LONG
datatypes.<http://docs.oracle.com/cd/B10500_01/server.920/a90842/apb.htm> http://docs.oracle.com/cd/E11882_01/server.112/e16604/apb.htm
cheers,
Jeff
On 28 June 2013 04:09, Denise Gwinn <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
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 28 2013 - 01:45:01 CEST