An after-insert trigger on the IWH.EDITION table is not useful, as only rows with a status value of start would be intercepted.
edition表上的after - insert触发器并非很有用，因为它只能截获其status值为start的记录行。
If one or more insert triggers are defined on a table, each insert will result in the execution of the actions prescribed in the trigger definition.
如果在一个表上定义了一个或多个进行insert操作的触发器，那么每次的insert都将引起触发器定义中的动作的执行。
A workaround to this is to supply a default value to the not NULL column whose value comes from a BEFORE INSERT TRIGGER, so that the constraint is not violated.
一种解决方法是给从BEFORE INSERT触发器取得值的NOT null列提供默认值，这样就不会违反约束。
In Oracle 10g, if there is a BEFORE INSERT TRIGGER and a NOT NULL constraint on a table, then the BEFORE TRIGGER is executed first, and then the constraint check is performed.
在Oracle10g中，如果表上同时存在BEFORE INSERT触发器和NOT NULL约束，那么先执行BEFORE触发器，然后执行约束检查。
Note: Alternatively you can create a database trigger to capture every INSERT on your table and tell it to validate the data as XML using the XMLVALIDATE function before performing the INSERT.
注意：您也可以选择创建一个数据库触发器来捕捉表上的每个INSERT操作，并告诉它在执行INSERT之前使用XMLVALIDATE函数验证XML数据。
In trigger terminology, the INSERT, DELETE, or UPDATE that causes a trigger to be fired is known as the triggering event.
在触发器术语中，INSERT、DELETE或者UPDATE这些使得触发器启动的事件被称作触发事件。
In addition, triggers can now contain UPDATE, DELETE, and INSERT operations together in a single clause as the trigger event. For example.
另外，触发器现在可以在单一子句中同时包含UPDATE、DELETE和INSERT操作，作为一个触发器事件。
When a specified SQL operation — a DELETE, INSERT, or UPDATE — occurs on a table, a trigger can be activated that defines a set of actions.
当一个指定的SQL操作(如DELETE,INSERT，或者是UPDATE操作)作用于某张表时，一个定义了一组操作的触发器就可以被激活。
If there were a trigger, for example, you would see that reflected in one or more additional insert, Update, or Delete entries in the access plan.
例如，如果有一个触发器的话，那么就会在访问计划中的一个或多个insert、Update或Delete条目中反映出来。
If there were a trigger, for example, you would see that reflected in one or more additional insert, Update, or Delete entries in the access plan.
例如，如果有一个触发器的话，那么就会在访问计划中的一个或多个insert、Update或Delete条目中反映出来。
应用推荐