Re: Copying Long columns

You can use COPY command in SQL*PLUS

Leo

Thomas Sommerfeld wrote:

> Hi,
>
> in Oracle 7.x there is only one way to copy a row with a long raw
> column
> to another row. You have to select the row with an external program
> and
> insert or update the other row. There's no way to do this with SQL or
> pl/sql directly. With pl/sql you can copy a row with a long raw
> column,
> if the value in the long raw column is smaller than 32K. If you are
> interested in the pl/sql code for this job, please mail me.
>
> Bye
> Thomas
>
> Sabarinath Nair wrote:
>
> > Hi,
> >
> > In our application, I need to copy some rows from one table to the
> > same
> > table (basically an insert from select). This does not work on
 tables
> > which have a long or long raw column. Is there a way to acheive
 this.
> >
> > Any help is apreciated.
> >
> > Thanks in advance
> > Sabari
>
>
> -------------------------------------------------------------------------------------------------------------
>
> Thomas Sommerfeld <Thomas.Sommerfeld_at_Baden-Online.de>
> Softwareentwicklung Sommerfeld
>
> Thomas Sommerfeld
> Softwareentwicklung Sommerfeld <Thomas.Sommerfeld_at_Baden-Online.de>
> Im Stenglenz 12a Work: +49 7803 980914
> Berghaupten Fax: +49 7803 980916
> 77791 Netscape Conference Address
> Deutschland Netscape Conference DLS Server
> Additional Information:
> Last Name Sommerfeld
> First Name Thomas
Received on Tue May 19 1998 - 00:00:00 CDT