database - Oracle update where select statement returns multiple row error -

hi have table this:

id name number

1 john 91234567

2 tom 98765432

3 ken 91357246 ...

i trying change number [91234567] number single row query returns more 1 row.

my statement:

update table set number = '9000000' id = (select id table number = '91234567') 

perhaps have record same number further down table.

since not have access id, how can change statement? thanks.

try use in instead of =

update table  set number = '9000000'  id in (select id table number = '91234567')