I need a trigger or something which will be launch when i open a table with a "select" sentence...I know that triggers per se only work with "update, insert or delete" (DDL or DML) but I want to know if I can do something that works like a trigger but only when I do a "select" command...I know also that I can write code on the client side to implement something seemless but I would like to build something on the server(DB) side...
pd. IBM Informix get something like this
SELECT Statements That Execute Triggered Actions:
"CREATE TRIGGER hits_trig SELECT OF col_a ON tab_a REFERENCING OLD AS hit FOR EACH ROW (INSERT INTO hits_log VALUES (hit.col_a, CURRENT, USER));"
So I guess Oracle...maybe get something equal to it?
September 20, 2006 6:40 PM
July 10, 2013 3:48 PM