Update the NBA a1 SET jj1=(... And sj2 BETWEEN the date '2007-07-1' and the date '2020-12-31') where sj2 BETWEEN date 'I - 07-01' and date 'I - 12-31';
Can the update statement above, use the begin, For circulation form, such as the data from 2007 to 2020, according to the updated every quarter or every month, until the end of 2020, each quarter or month do commit after an update, then the next quarter or month next update

Similar to the

Declare
I the INTEGER:=0;


For I in 2007.. 2020 loop
UPDATE the NBA a1 SET jj1=(... And sj2 BETWEEN date 'I - 07-1 and the date' I - 12-31 ') where sj2 BETWEEN date 'I - 07-01' and date 'I - 12-31';

commit;
End loop;


The end;

My above statement is wrong, because the execution error, but I don't know how to change, don't know what a good teacher and friend help modify, thanks!