how to see all the inserted rows of a particular date
Question posted by: rohitbasu77
(Member)
on
March 25th, 2008 01:05 PM
Hi friends,
how to see all the inserted rows of a particular date of a table.
regards
rohit
Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).
|
|
March 25th, 2008 01:09 PM
# 2
|
Re: how to see all the inserted rows of a particular date
Quote:
Originally Posted by rohitbasu77
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?
|
|
March 25th, 2008 01:12 PM
# 3
|
Re: how to see all the inserted rows of a particular date
Quote:
Originally Posted by amitpatel66
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...
|
|
|
March 26th, 2008 05:01 AM
# 4
|
Re: how to see all the inserted rows of a particular date
Quote:
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...
|
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
|
|
|
March 26th, 2008 09:32 AM
# 5
|
Re: how to see all the inserted rows of a particular date
Quote:
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
|
ok..... but one can use SYSDATE in where clause
|
|
|
March 26th, 2008 09:43 AM
# 6
|
Re: how to see all the inserted rows of a particular date
Quote:
Originally Posted by rohitbasu77
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?
|
|
|
March 26th, 2008 09:20 PM
# 7
|
Re: how to see all the inserted rows of a particular date
See my reply at http://www.thescripts.com/forum/thread786881.html
|
|
|
March 27th, 2008 01:32 AM
# 8
|
Re: how to see all the inserted rows of a particular date
Quote:
Originally Posted by rohitbasu77
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)
Code: ( text )
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
Last edited by amitpatel66 : March 27th, 2008 at 06:17 AM.
Reason: code tags
|
|
|
March 27th, 2008 05:52 AM
# 9
|
Re: how to see all the inserted rows of a particular date
Quote:
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
|
Thanks Mala,
The issue is resolved by Pelle...
Not the answer you were looking for? Post your question . . .
180,801 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).
|
|
|
Top Oracle Forum Contributors
|
