Yes, I know I can achieve that very easily through triggers... however, I was wondering whether it is possible to catch outliers only for a certain column in a table through audit.For example. Whenever someone updates (or a row gets inserted) with a value above 1000, let's say, the info about that goes into the audit table.I researched CREATE DATABASE AUDIT SPECIFICATION statement and so far I haven't found a way to add the condition to the audit.for example...ADD (INSERT , UPDATEON issue_table /* can I here add column and a condition, somehow? */BY PUBLIC)
Audit options
Posted - 2010-08-14 : 10:14:10
