Cacher is the code snippet organizer for pro developers

DELETE FROM EMPLOYEE_PROFILE 
WHERE MSS_UNIT_TERM_DT < SYSDATE;

UPDATE EMPLOYEE_PROFILE 
SET EMAIL = '##application.programmer_email##';

DELETE
FROM EMPLOYEE_TIMES
WHERE END_DTTM      < SYSDATE - 84
OR EMPLOYEE_ID NOT           IN
  ( SELECT DISTINCT EMPLOYEE_ID FROM EMPLOYEE_PROFILE
  );