admin 2020.10.17 03:10 Views : 82
BEGIN
DELETE FROM DEDUCTION_YEAR;
INSERT INTO DEDUCTION_YEAR (DTYPEID)
Select DTID from DEDUCTION_TYPE
WHERE ACTIVE = 'A'
ORDER BY DTID;
COMMIT;
END;