how to see all the inserted rows of a particular date

Originally Posted by rohitbasu77

Hi friends,

how to see all the inserted rows of a particular date of a table.

regards
rohit

Originally Posted by amitpatel66

Could you post your table structure, the query that you tried for achieving your results?

Originally Posted by rohitbasu77

say:

select * from EMP;

but it gives all the rows, i need to find only the rows inserted by today or yesterday...

Originally Posted by amitpatel66

If you have any column that stores the date when the record was inserted only then you will be able to get the records for a particular day. Else you cannot retrieve the records based on today or tomorrow date

Originally Posted by rohitbasu77

ok..... but one can use SYSDATE in where clause

Originally Posted by rohitbasu77

Hi friends,

how to see all the inserted rows of a particular date of a table.

regards
rohit

Originally Posted by Mala232

Hi rohit ,

here is the query .if your table has a column insrt_ts (insert timestamp)

select * from <table_name> where insrt_ts = sysdate (for todays inserted records)

select * from <table_name > where insrt_ts = sysdate -1 ( for yesterdays)

hope this helps you .

Mala