After the execution of the UPDATE, INSERT, and DELETE statements, an additional variable is available to check the result of the statement.
执行完update、INSERT和delete语句后,将使用额外的一个变量来检查语句的结果。
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都将引起触发器定义中的动作的执行。
However, REFRESH IMMEDIATE system-maintained MQTs are updated with changes made to the underlying tables as a result of insert, update, or delete operations.
但是,对于 REFRESH IMMEDIATE 类型的系统维护的 MQT,可以通过 对底层表的更改(即 insert、update 或 delete 操作)来更新。
应用推荐