OraFAQ Forum: SQL & PL/SQL » How to Append text to a data in a column

Home » SQL & PL/SQL » SQL & PL/SQL » How to Append text to a data in a column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Append text to a data in a column [message #20538]

Mon, 03 June 2002 09:35

Naveen Patlola
Messages: 3
Registered: January 2002

Junior Member

I have a field of datatype Long in a table that already has some data in it. How can I append text into that field. I am using Oracle db version 7.3.
Please let me know.

Report message to a moderator

Re: How to Append text to a data in a column [message #20539 is a reply to message #20538]

Mon, 03 June 2002 10:19

Naveen Patlola
Messages: 3
Registered: January 2002

Junior Member

If I do the following I am getting an error message.

update logs set LONG_DESC=concat(LONG_DESC,'again') where log_id=30026
*
ORA-00932: inconsistent datatypes

PLEASE HELP

Report message to a moderator

Re: How to Append text to a data in a column [message #20554 is a reply to message #20538]

Tue, 04 June 2002 08:28

ram
Messages: 95
Registered: November 2000

Member

How can you insert a string into long data field? LONG_DESC seems to be a long data type, and you are trying to concat with string.

If LONG_DESC is varchar, try LONG_DESC || 'again' or concat should work too.

Report message to a moderator

Previous Topic:	running an sql script file??
Next Topic:	DeadLock giving trouble!!!!!! Very urgent !!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 04:57:01 CDT 2024