Below is the oracle query which can be used to retrieve the records updated in last one hour
select count(*) from table where last_updated_date between sysdate-1/24 and sysdate;
select count(*) from table where last_updated_date between sysdate-1/24 and sysdate;
No comments:
Post a Comment