OraFAQ Forum: SQL & PL/SQL » Update with concatenation

Home » SQL & PL/SQL » SQL & PL/SQL » Update with concatenation

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

Update with concatenation [message #2773]

Mon, 12 August 2002 15:13

NiGger
Messages: 6
Registered: July 2002

Junior Member

Hi��

I'm trying to update all the rows of one column of a table adding to the existing value a string , something like that :

value before update: 01
value after update: TABPP01

As yo can see i'm adding the value TABPP to an existing value in the column ( the definition of the column is varchar2 ) , i suposed that the right script was something like that:

Update schema.table
SET column = TABPP||column_data
WHERE columnX is not null(or any condition);

What am i doing wrong?
Thankz in advanced

Report message to a moderator

Re: Update with concatenation [message #2775 is a reply to message #2773]

Mon, 12 August 2002 15:48

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

You are very close:

update t
   set c = 'TABPP' || c
 where ...;

Report message to a moderator

Previous Topic:	Query to select PK. / how to insert and update CLOB?
Next Topic:	Passing a string list to a procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 08:57:12 CDT 2024