triggers -- distinguish between bulk and individual changes

I am trying to create audit routines in which bulk data changes to the entire table are logged only once, while logging each manual change to individual records. So I think I need to figure out any of the following:

• From within a row-level trigger, is there any way to identify whether other rows are being affected by the same SQL statement?
• From within a statement-level trigger, is there any way to determe how many rows are being affected?
• From within a statement-level trigger, is there any way to determe the SQL statement being run?

Thanks. Received on Mon May 21 2001 - 16:33:14 CDT