Re: Update nth Byte of a varchar2 field
From: Ethel Aardvark <bigjobbies_at_hotmail.com>
Date: 20 Mar 2003 06:30:24 -0800
Message-ID: <1a8fec49.0303200630.1c014c67_at_posting.google.com>
Date: 20 Mar 2003 06:30:24 -0800
Message-ID: <1a8fec49.0303200630.1c014c67_at_posting.google.com>
Something like (and this is untested as my server is down right now):
UPDATE table
SET vField = SUBSTR (vField, 1, 3) || 'Y' || SUBSTR (vField, 5);
ETA
"Peter Kowalski" <PKowalski2_at_gmx.de> wrote in message news:<1048148218.963197_at_news.thyssen.com>...
> Hallo,
> I want to update the 4th char in a varchar2 Field :
>
> vfield : varchar2(32);
>
> update table set vfield[4] = 'Y';
> ---------------------^ ORA-00927: = expected
>
> How can I do this ?
>
> Thanks
Received on Thu Mar 20 2003 - 15:30:24 CET