Update nth Byte of a varchar2 field

From: Peter Kowalski <PKowalski2_at_gmx.de>
Date: Thu, 20 Mar 2003 09:18:33 +0100
Message-ID: <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 - 09:18:33 CET

This message: [ Message body ]
Next message: Ethel Aardvark: "Re: database table as file system"
Previous message: Guido Konsolke: "Re: How can i copy data from one table in one tablespace to table in a difft tablespace?"
Next in thread: Ethel Aardvark: "Re: Update nth Byte of a varchar2 field"
Reply: Ethel Aardvark: "Re: Update nth Byte of a varchar2 field"
Reply: Tony: "Re: Update nth Byte of a varchar2 field"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message