today:
593
yesterday:
719
Total:
1,770,377

Technology

CREATION DEDUCTION TYPE

admin 2020.10.17 04:10 Views : 90

BEGIN

 

DELETE FROM DEDUCTION_YEAR;

 

INSERT INTO DEDUCTION_YEAR (DTYPEID)

Select DTID from DEDUCTION_TYPE

WHERE ACTIVE = 'A'

ORDER BY DTID;

 

COMMIT;

END;