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

Home -> Community -> Usenet -> c.d.o.server -> How to copy LONG column

How to copy LONG column

From: Tom Wilson <tdwilson_at_mindspring.com>
Date: 1997/05/20
Message-ID: <33826895.2A40@mindspring.com>#1/1

I need to copy a long varchar from one table to another using

UPDATE tab1 SET longcol = (SELECT longcol2 FROM tab2 WHERE tab1.key=tab2.key);

But I get an error that this is an invalid use of a LONG column. How do I insert or update a long column by copying a value from another column?

Tom Received on Tue May 20 1997 - 00:00:00 CDT

Original text of this message

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