|
Hello friends,
I have a table with the following structure Create table postablestatus ( tablename varchar(30) NOT NULL, updatetime timestamp, reccount int, size int, CONSTRAINT postablestatus_pkey PRIMARY KEY(tablename) ) WITH (oids = false); 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 thanks in advance arvind |
