Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


1
(click on this box to dismiss)

What is a statement event trigger?

I saw that CUBRID supports INSTANCE events and STATEMENT events for triggers. What is the difference between them? Can you provide an example for when one should be used instead of the other?

link comment (0)
asked 3 years ago
eusto
204
11 Answers
1

For example, you have three rows in "fruit" table like following

and both "instance trigger" and "statement trigger" are made in this table for update.

If you execute "update fruit set name = 'grape",

instace trigger will be fired three times against each rows and statement trigger will be fired just one time.

That is to say, instance trigger is run on a row and statement trigger is run on one sql statement.

ID

name

1

apple

2

banana

3

cherry

 

link comment (0)
answered 2 years ago
choi
36
tagged




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: