11/27/2023 0 Comments Create trigger after 100 updates![]() ![]() RAISE_APPLICATION_ERROR(-20001, 'the discount percent cannot be less than 0.') RAISE_APPLICATION_ERROR(-20001, 'the discount percent cannot be greater than 100.') ![]() connect mgs/mgs ĬREATE or replace TRIGGER products_before_update Test this trigger with an appropriate UPDATE statement.Įither if statement doesn't work or I am getting message that table is mutating, so the trigger can't see it. If the new discount percent is between 0 and 1, this trigger should modify the new discount percent by multiplying it by 100. This trigger should raise an appropriate error if the discount percent is greater than 100 or less than 0. Create a trigger named products_before_update that checks the new value for the discount_percent column of the Products table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |