Trigger or something like that for Select sentence-2
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 by 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 or semeless
Software/Hardware used:
Software/Hardware used:
ASKED:
September 20, 2006 6:40 PM
UPDATED:
September 22, 2006 10:39 AM
RELATED QUESTIONS
Answer Wiki:
Forget triggers. You should consider architecting a Data Access layer in your system. Removing all embedded SQL from programs and replacing with a call to a service (for example, stored procedure) that returns a result set as well as performing your logging.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
