Re: How to Determine if Table Modified

In article <L9Wr5.14716$K4.579990_at_newsread1.prod.itd.earthlink.net>,

        "George cova" <nojunkmail_at_earthlink.net> writes:
> How can I determined if an Oracle table was modified. In other words, I
> would like to know if a record was entered, deleted,or modified. Is there
> something in the Dictionary that I can query that will tell me like the last
> dateTime table modified? Or maybe some other field or value that counts the
> number of times table was modified?

I believe Oracle does not do this. However, you can create a database trigger that will update a date-field (perhaps in another table) to implement this by yourself.
Beware, though, that your trigger won't trigger itself, or you'll have an infinite loop.

<snip reason>

-- 
 12:39am  up  1:34,  3 users,  load average: 2.22, 1.45, 1.22

Voor een vertaling van Documentation/Configure.help naar het Nederlands:
http://users.pandora.be/wouter.verhelst/configure.html

You are an insult to my intelligence!  I demand that you log off immediately.