Re: query for altered since

From: Martijn Tonies <m.tonies_at_upscene.removethis.com>
Date: Fri, 17 Mar 2006 15:54:43 +0100
Message-ID: <121ljdus2nrk0ab@corp.supernews.com>

> Add a column called LAST_UPDATED_TIME DATE
>
> Add a trigger for before insert

and "before update" :-)

> :new.last_updated_time := sysdate;
>
>
> select * from <table> where last_updated_time >= sysdate - <whatever
> timeinterval>;

-- 
Martijn Tonies
Database Workbench - development tool for Oracle, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Received on Fri Mar 17 2006 - 08:54:43 CST