The before trigger and check constraint on a table XML value always ensures that the XML values are valid as per the specified schema.
对一个表XML值应用before trigger和检查约束,往往可以确保 XML值对于指定模式是有效的。
Similar to the before trigger, the IS VALIDATED ACCORDING TO XMLSCHEMA clause can be used in the check constraints to enforce the validation.
与before trigger类似,可以在检查约束中使用ISVALIDATEDACCORDINGTO XMLSCHEMA 子句来加强验证。
You'll notice that in this case (a before trigger invoked by an update), you can only specify that the trigger fire on each row, not each statement.
您将注意到,在这种情况下(一个在UPDATE之前被激活的触发器),您只能指定触发器针对每行而不是针对每个语句触发。
For example, if a before trigger supplies value to a NOT NULL column, then the before trigger is executed first and a value is supplied to the column so that the NOT NULL constraint isn't violated.
例如,如果一个BEFORE触发器给一个NOTnull列提供值,那么先执行BEFORE触发器,给列提供值,所以不会违反NOT NULL约束。
Creating a BEFORE trigger statement to enforce automatic validation.
创建强制执行自动验证的BEFORE触发器语句。
Another option is to convert a BEFORE trigger to an AFTER trigger, as long as it does not affect the functionality.
另一种方法是把BEFORE触发器转换为after触发器,前提条件是这不会影响功能。
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触发器,然后执行约束检查。
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触发器,然后执行约束检查。
应用推荐