I want to use a trigger to trigger another table trigger to do, is a piece of table, when the trigger this trigger, the other table is banned insert data, this how to do it, please urgent

CodePudding user response:

The other a trigger is built on the table, write the rollback transaction, can insert data is prohibited.

CodePudding user response:

reference 1/f, started the first response:

build a trigger another table, write the rollback transaction, you can insert data is prohibited.

I don't want to trigger that can be inserted if it is normal operation