update query question

Question

i have this table MEN

Fname
aaa
bbb
ccc
aaa
aaa
bbb
ggg

i need query that replace all the aaa - in - ZZZ

Fname
ZZZ
bbb
ccc
ZZZ
ZZZ
bbb
ggg

how to do it on Oracle query ?

thanks in advance

Answer 1

UPDATE MEN SET Fname='ZZZ' WHERE Fname='aaa';

see http://psoug.org/reference/update.html

Answer 2

Will work not only in Oracle

update MEN
set Fname='ZZZ'
where Fname='aaa';