-- q4b UPDATE DT951 SET DI010459 = add_months(DI010459 , 2000 * 12) WHERE TO_NUMBER(TO_CHAR(DI010459, 'YYYY')) < 1970; UPDATE DT951 SET DI010460 = add_months(DI010460 , 2000 * 12) WHERE TO_NUMBER(TO_CHAR(DI010460, 'YYYY')) < 1970; -- q5b UPDATE DT478 SET DI000622 = add_months(DI000622 , 2000 * 12) WHERE TO_NUMBER(TO_CHAR(DI000622, 'YYYY')) < 1970; UPDATE DT478 SET DI000623 = add_months(DI000623 , 2000 * 12) WHERE TO_NUMBER(TO_CHAR(DI000623, 'YYYY')) < 1970; -- q6b UPDATE DT002 SET DI024786 = add_months(DI024786 , 2000 * 12) WHERE TO_NUMBER(TO_CHAR(DI024786, 'YYYY')) < 1970; UPDATE DT002 SET DI024787 = add_months(DI024787 , 2000 * 12) WHERE TO_NUMBER(TO_CHAR(DI024787, 'YYYY')) < 1970; -- q7b UPDATE DT901 SET DI005503 = add_months(DI005503 , 2000 * 12) WHERE TO_NUMBER(TO_CHAR(DI005503, 'YYYY')) < 1970; UPDATE DT901 SET DI005504 = add_months(DI005504 , 2000 * 12) WHERE TO_NUMBER(TO_CHAR(DI005504, 'YYYY')) < 1970;