where a) tablename - is the name of table where a record is inserted,updated or deleted b) updatetime - the time when table was updated (w/o timezone) c) reccount - records in table d) size - bytesize of the table
-- for example, if a table called item_master had 1 record and a new record is inserted and it's size is 2000 bytes
> postablestatus must have a entry like
item_master 08/12/2013 12:40:00 2 2000 --
I request to know how to write a trigger in PLSQL so that the postablestatus is updated whenever a record is inserted,updated or deleted in item_master
PLEASE NOTE : a new record must be created if the item_master is not present in postablestatus
You will get more information from below link for creation of audit trigger: