Query is -
DELETE FROM ECOOVERLAYEVALUATION
WHERE creationdate < sysdate - 2;
COMMIT;

This table "ECOOVERLAYEVALUATION" in turn connects to other tables and deletes records from them.

I can not use Truncate as I do want to retain data for past two days.