Home » SQL & PL/SQL » SQL & PL/SQL » How to retrive the latest updated records (Oracle 10g, WIN XP)
How to retrive the latest updated records [message #335691] Wed, 23 July 2008 05:26 Go to next message
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
Re: How to retrive the latest updated records [message #335696 is a reply to message #335691] Wed, 23 July 2008 05:34 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Add a timestamp column
Re: How to retrive the latest updated records [message #335697 is a reply to message #335691] Wed, 23 July 2008 05:37 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please SEARCH before posting, this has been asked about a million times.

Regards
Michel
Previous Topic: Instance terminated by user, pid=27875
Next Topic: Left outer joins over a HS link
Goto Forum:
  


Current Time: Fri Dec 09 11:33:28 CST 2016

Total time taken to generate the page: 0.09993 seconds