Re: when table was last changed?

In article <4bpmmh$m6u_at_neon3.neonramp.com>, glc <glc_at_neonramp.com> wrote:
>I create a LAST_CHANGE_DATE column in the table and and a trigger to plug
 SYSDATE
>into it on insert, update or delete.

thank you for the idea -- i assume i'd do a

  SELECT MAX(LAST_CHANGE_DATE) FROM MyTable

or something similar?

unfortunately, my application doesn't "own" all of the tables that i have to check, so i'm still looking for another way...

*------------------------------------*
*  jim cox
*

*------------------------------------*