Oracle Update issues

Little brother to encounter an Oracle update problem, ask you to help:

There are several records in the Zz_file, similar in format:

(zz01 zz02)

gpyi010 apyi/gpyi010

gpyi020 apyi/gpyi020

.....

The younger brother wants to zz01 the Gpy the record which begins with the $apyi to change into $gpyi

I tried the update zz_file set zz02[1]= ' G ' where ...

Unsuccessful, do you know how to change part of the content of the method?

Thanks for the first.

Try a translate function.

FUNCTION TRANSLATE

(String_in in VARCHAR2,

Search_set in VARCHAR2,

Replace_set VARCHAR2)

Return varchar2//Find a string and replace her with another string.

However, if you have more than one search_set in the Zz02 field, it will be replaced.

Update AA

Set b= translate (b, ' apyi ', ' gpyi ')

where substr (b,6,10) = ' gpyi ';

Good