Oracle get records updated in last one hour
just Subtract 1/24 from sysdate to get the time of 1 hour ago
select count(*) from my_table where last_updated_date >= (sysdate-1/24)
just Subtract 1/24 from sysdate to get the time of 1 hour ago
select count(*) from my_table where last_updated_date >= (sysdate-1/24)