get records updated in last one hour in oracle

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;

No comments:

Post a Comment