Procedure for changing data in Oracle SQL?

Question

Oracle

Can you help write a code that will check the ntype status, if ntype is 1 then the status needs to be changed from 0 to 1.
I tried to write a c FOR loop but it doesn’t work.
sql fiddle

Answer 1

UPDATE BONUS_FOR_AGENT SET STATUS = 1 WHERE NTYPE = 1 AND STATUS = 0;