Re: delete a oracle table at regular interval of 7 days
At first you have to figure out how to select the records to delete. In oracle a DATE typed value is actually an integer day and the numbers right to the comma are the time. You can therefore select the data to delete with a simply subtraction like this:
delete from ORDERS where ORDER_DATE > (sysdate - 7)
This statement can by run within a tOracleRow component and if you schedule this job every day you will get a kind of house keeping of the data for 7 days.