Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to append data to a long datatype?

Re: How to append data to a long datatype?

From: Noodles <noodles_at_aol.com>
Date: 1997/11/14
Message-ID: <19971114122401.HAA09430@ladder01.news.aol.com>#1/1

If your new concatenated LONG Datatype length is less than 2000 characters in  length, you can use PL/SQL to retrieve the data into a cursor and then insert  the new lengthened long datatype into a new table. Then just drop the old  table and rename the new table.

 If the overall data length is greater than 2000 characters, you need a higher  version of Oracle which has some built-in Long datatype parsing procedures OR  you will need to concatenate the data outside of Oracle and reload the table.  

Cliff
(noodles_at_aol.com) Received on Fri Nov 14 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US