what is meant by mutating error in triggers? Could you please explain in detail.
Also pls. tell me when to use Triggers as most of the programmability can be coded using Stored procedures, any specify areas where Trigger plays a bigger role compared to Stored procedures.

Thanks in advance

Thanks,
Chandra

__________________
Thanks,
Chandra

Triggers and stored procedures are completely different based on what executes them. A trigger as the name implies is "triggered" on an event. You can have an Insert Trigger and an Updated trigger for example. So the insert trigger code executes when you insert a row into a table. The Update Table trigger code executes when you do an update. If you do a select or delete on the table no triggers execute. A stored procedure is code that sits on the server until you specifically call it. Similar to running an *.exe on windows. It sits there till you call it up.

Good luck with your home work or interview.