VERY urgent please help me -Trigger [message #1428] |
Mon, 29 April 2002 21:04 |
nelson
Messages: 30 Registered: February 2000
|
Member |
|
|
Hai ora guru’s
Please help me
I have to insert 3 records and
Update 2 records and
Delete 5 records – totally 10 records.
If I am going to write a trigger
For updation, insertion and deletion-
that is statement level trigger,
how may times will it fire. I mean how many time
the statement level trigger will fire for these operation.
And
How may times the row level trigger gets fired.
Very urgent
Nelson
|
|
|
Re: VERY urgent please help me -Trigger [message #1429 is a reply to message #1428] |
Mon, 29 April 2002 22:54 |
Amit
Messages: 166 Registered: February 1999
|
Senior Member |
|
|
I think Trigger will fire each time for insert,update,delete for each record
but one at time
means when you insert one record trigger will be fired
hope your doubt will be cleared.
|
|
|
Re: VERY urgent please help me -Trigger [message #1446 is a reply to message #1428] |
Wed, 01 May 2002 04:33 |
John R
Messages: 156 Registered: March 2000
|
Senior Member |
|
|
Homework time is it?
The statment level trigger will fire once for each statement (does just what it says on the label).
The row level trigger will fire once for each row (tricky isn't it?)
So, assuming that you have one insert statement that inserts 3 rows, the statement level On Insert trigger will fire once and the row level On Insert trigger will fire 3 times.
I'm sure you can work out the Update and Deletes from here.
I'm sure you can work out the behavoiu
|
|
|