Re: Time Stamp of a table????

jizwang_at_cc.umanitoba.ca (Dr. J. Wang) writes:

>Is there a way to determine (via time stamp) if a table has being updated
>(/inserted/deleted). I used to use COMMENT statement following a updating so
>that I can check LAST_DDL_TIME in table USER_OBJECTS. Unforturnately I have to
>find an alternative since DLLs are not supported in a trigger body. In an
>application, I have to inform all clients (when they login) that a new copy
>(update/insert/delete) of table is available. How can I do it??

Off the top of my head...

After insert/update/delete trigger on table, with timestamp, that logs changes to a log table? Application can check the update table on login, according to whatever rules you set. Not too bad for few tables, but I suppose it could get unwieldy with many many tables...

-- 
/(o\ Nathan D. Hughes
\o)/ nhughes_at_umich.edu