• update syntax using cursor is as follows

    update <table name> set <condition>

    where current of <cursor name>

    it updates one row at a time. based on the position of cursor