Constraints Supports, primary, foreign, unique, not null constraint.
约束支持主键、外键、惟一和非空约束。
So in the example above, the NOT NULL constraint would get violated, and the INSERT statement would error out.
因此,在上面的示例中,会违反NOT NULL约束,INSERT语句会出错。
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触发器,然后执行约束检查。
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触发器给一个NOT null列提供值,那么先执行BEFORE触发器,给列提供值,所以不会违反NOT NULL约束。
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触发器给一个NOT null列提供值,那么先执行BEFORE触发器,给列提供值,所以不会违反NOT NULL约束。
应用推荐