How to append data to a long datatype?

From: shaolin <skang_at_granax.dot.com>
Date: 1997/11/12
Message-ID: <346A3D99.615C864D@granax.dot.com>#1/1

i have been searching around for the solution to append data to a long datatype, but solution that i found still doesn't work for me.

I suppose this should work, but i got error:

SQL> update tt set info = ' how are you '||TO_CHAR(info) where id='0002'; update tt set info = ' how are you '||TO_CHAR(info) where id='0002'

                                              *

ERROR at line 1:
ORA-00932: inconsistent datatypes

HOw can i append? I am using oracle 7.2...

thanks.

-- 
-----------------------------------------------------------------------------
Kang Soon Lai	skang_at_granax.com	| "If there is any religion that would
http://www.granax.com/~skang/		| cope with modern scientific needs
(913) 385 5481				| it would be Buddhism."
Software Engineer			|		--Albert Einstein
------------------------------------------------------------------------------
`When you say "I wrote a program that crashed Windows", people just stare at
you blankly and say "Hey, I got those with the system, *for free*".'
							--Linus Torvalds

Received on Wed Nov 12 1997 - 00:00:00 CST