Home » SQL & PL/SQL » SQL & PL/SQL » How can I find the last_updated row in a table?
How can I find the last_updated row in a table? [message #601] Sun, 24 February 2002 19:50 Go to next message
mhy
Messages: 15
Registered: March 2001
Junior Member
dear sir:
I have two database servers (A & B) ,rhe server A is for business,and the server B stored some important tables of server A.I hope,if somebody changed the data of server A,the changges can be done on th server B automatically.So I want to make a trigger,but I can't find the last_updated row,and the table is big .How can I do?
thanx a lot!

Report message to a moderator

Re: How can I find the last_updated row in a table? [message #611 is a reply to message #601] Mon, 25 February 2002 00:29 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
i do not think it is possible to get last updated rows. why do not u use trigger to populate the table in server B. why u want last updated rows in the first place. please clarify ..

Report message to a moderator

Previous Topic: a statement
Next Topic: Self join
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 17:26:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.