Sql script til Oracle db

Hej kan nogen fortælle mig om det her er korrekt+

UPDATE product SET pro_group = '999' WHERE pro_group = '299';
COMMIT;
Update product set sub_group ’9991’ where field8 = ‘ZPDS‘
COMMIT;
Update product set sub_group ’9992’ where field8 = ‘ZPOP’ and field8 = ‘HALB’
COMMIT;
Update product set sub_group ’9993’ where field8 = ‘ZPRE ‘
COMMIT;

eller der det sådan
Update product set pro_group='999', sub_group ’9993’ where pro_group = '299' and field8 = ‘ZPRE ‘ and field8 = ‘ZPOP’ and field8 = ‘HALB’ and field8 = ‘ZPDS‘
COMMIT;