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

Home -> Community -> Usenet -> c.d.o.tools -> Long column

Long column

From: Paolo <none_at_none.org>
Date: Fri, 18 Aug 2000 19:05:09 +0200
Message-ID: <8njq3u$k3r$1@fe1.cs.interbusiness.it>

Hi all,

How to update a LONG column with a string constant? Example:

( coly long )

update tablex
set coly = coly || '123456abcd'
where colh = 1;

I receive an error: ORA-00932: inconsistent datatypes

Please help me

Best regards Paolo Received on Fri Aug 18 2000 - 12:05:09 CDT

Original text of this message

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