Re: query for altered since

Add a column called LAST_UPDATED_TIME DATE

Add a trigger for before insert

:new.last_updated_time := sysdate;

select * from <table> where last_updated_time >= sysdate - <whatever timeinterval>; Received on Fri Mar 17 2006 - 08:23:29 CST