I know how to use SQL but have some specific requirement to do from myself right now and i am a bit confused.

I have a table that has documentnumber column and here is the table information simply :

```
Documentnumber VIB       Status
1              TAS7002   OK
1              TAS7003   OK
1              TAS7004   OK
2              TAS7002   OK
2              TAS7003   OK
2              TAS7004   OK

```

What i want to update only one row, foreach different documentnumber which is in (1,2). Example could be :
***Update documentnumber=1 and VIB = TAS7002 && documentnumber=2 and vib=TAS7002***
It can be randomly choosen about which vib number should be updated, can be any one of them(TAS7002,TAS7003 etc.), but i would like to put this query into one query. The reason is that i have documentnumbers as a list but not vib numbers...

What i've tried is that :

```
update bshm_sp_pidok_objlink
set status = 'NEW'
where documentnumber in
(1,2)
and status = 'OK'
and rownum = 1;

```

Can you please check what i am doing wrong ?