Home » SQL & PL/SQL » SQL & PL/SQL » insted of trigger
insted of trigger [message #223780] Sun, 11 March 2007 06:03 Go to next message
mkr_oracle
Messages: 6
Registered: March 2007
Location: chennai
Junior Member
hi,

if i fire insted of trigger in complex views, means wt happend in

background.


regards,
mohan
Re: insted of trigger [message #224115 is a reply to message #223780] Tue, 13 March 2007 02:28 Go to previous messageGo to next message
subramanian.sp
Messages: 13
Registered: March 2007
Location: Pune
Junior Member
If you do some dml operations on a table, the Instead of trigger will fire and do the same on all the tables.
Re: insted of trigger [message #224119 is a reply to message #223780] Tue, 13 March 2007 02:37 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
The instead of trigger does exactly what its name says:
Instead of the operation you requested on the view (eg. insert) it executes the trigger.
Normally, you would use this to translate the requested dml to the underlying tables.
Previous Topic: DBMS_JOBS
Next Topic: can not insert into table
Goto Forum:
  


Current Time: Sat Dec 10 20:40:47 CST 2016

Total time taken to generate the page: 0.08624 seconds