where last_updated_date < trunc(sysdate-100)
where trunc(last_updated_date+100) < trunc(sysdate)
797846 wrote:Oracle does not automatically keep track of when every change was made. If you need that information, you have to store it yourself.
... There are some concurrent program and it is running on every 6hrs and it will update the status column as Active or OBSOLETE and it will update the last_updated_date column as
sysdate and then how we can identify whether the service level age is more than 100 days as OBSOLETE.means the service level is more than 100 days as OBSOLETE.