How to retrive the latest updated records [message #335691] |
Wed, 23 July 2008 05:26  |
dev_sri
Messages: 4 Registered: July 2008 Location: Hyderabad
|
Junior Member |
|
|
Hi all,
SQL> select * from test;
EMPNO ENAME SAL STATUS
---------- ---------- ---------- -----
1 sri 10000 I
2 kris 20000 I
3 sony 20000 I
I have a check constraint on the column STATUS (I - Insert, U - Update, D - Delete)...
Lets say i have 50,000 rows on the table.. now i need to know that what are the latest records that were updated in past 24 hrs(Using Trigger)?
Any help..
Regards
- sri
|
|
|
|
|