how to see all the inserted rows of a particular date

[rohitbasu77]

Hi friends,

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

regards
rohit

[amitpatel66]

Hi friends,

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

regards
rohit

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

[rohitbasu77]

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

say:

select * from EMP;

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

[amitpatel66]

say:

select * from EMP;

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

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

[rohitbasu77]

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

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

[amitpatel66]

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

You will compare SYSDATE with Which Column?

Could you please try and post back if any issues?

[PelleFork]

See my reply at http://www.thescripts.com/forum/thread786881.html

[Mala232]

Hi friends,

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

regards
rohit

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

[rohitbasu77]

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

Thanks Mala,
The issue is resolved by Pelle...