How many number of statements we can specigy in a trigger statement. I mean is there any limit on this ? Thanks in advance.
The trigger should just have one anonymous block, if I remember rightly. And in that anonymous block you can have more anonymous blocks, function calls and procedure calls. As many as you like, effectively.
See: http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_triggers.htm For more information
No one has followed this question yet.