Oracle query to get Data from table inserted in last 10 mins

select sysdate - 10/(24*60) from dual;

See above example to get sysdate minus ten minutes, now just add to your query

Or slightly more readable:

select *
  from mytable
 where lastupdatedDate > sysdate - interval '10' minute

select *
from mytable
where lastupdatedDate > sysdate - (10/1440)

A more readable version of this is given by Rob van Wijk here https://stackoverflow.com/a/893668/39430

Related