in my view if u are an oracle user mens you may use trigger..

trigger is executed automatically when an event occurs in a database.

such events are select,delete,update...

syntax:
create or replace trigger <trigger-name> <before/after> <event-name> on <table-name>
---------
---------
end;