Re: update character column

From: Taysha <eatme_at_joes.place>
Date: Wed, 02 Feb 2005 16:08:18 +0200
Message-ID: <4200df26$1@news.012.net.il>

jazzz_ wrote:

> 
> Użytkownik "jazzz_" <jazzz__at_poczta.onet.pl> napisał w wiadomości 
> news:ctqeps$9jr$1_at_atlantis.news.tpi.pl...
> 

>>Hi,
>>I have to update values in one column (character).
>>Now all values are like: "1234", "2345", "3456", and etc.
>>They have to be "1234A", "2345A", "3456A" etc.
>>Is there ane method to do this with sql+ ?
>>please help
>>
>>

> UPDATE table_name SET column_name=column_name+"A" > doesn't work :-(

Obviously not, since "+" is not the concatenation operator in "SQL*Plus".

update TABLE_NAME

    set COLUMN_NAME = COLUMN_NAME || 'A'

Good Luck,
Avi. Received on Wed Feb 02 2005 - 08:08:18 CST