Examine This Database Trigger

  • 4 Jan, 2012

    52. CREATE OR REPLACE TRIGGER prevent_gross_modification53. {additional trigger information}54. BEGIN55. IF TO_CHAR(sysdate, DY) = MON56. THEN57. RAISE_APPLICATION_ERROR(-20000,Gross receipts cannot be deleted on Monday);58. END IF;59. END;This trigger must fire before each DELETE of the GROSS_RECEIPT table. It should fire only once for the entire DELETE statement. What additional information must you add?1. BEFORE DELETE ON gross_receipt2. AFTER DELETE ON gross_receipt3. BEFORE (gross_receipt DELETE)4. FOR EACH ROW DELETED FROM gross_receipt

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.