Breaking News: Grepper is joining You.com. Read the official announcement!

compound trigger oracle

Carlos Roberto Báez Leiva answered on May 9, 2022 Popularity 6/10 Helpfulness 4/10

answer compound trigger oracle

compound trigger oracle

Comment

CREATE OR REPLACE TRIGGER compound_trigger_name
FOR [INSERT|DELETE]UPDATE [OF column] ON table
COMPOUND TRIGGER
   -- Declarative Section (optional)
   -- Variables declared here have firing-statement duration.
     
     --Executed before DML statement
     BEFORE STATEMENT IS
     BEGIN
       NULL;
     END BEFORE STATEMENT;
   
     --Executed before each row change- :NEW, :OLD are available
     BEFORE EACH ROW IS
     BEGIN
       NULL;
     END BEFORE EACH ROW;
   
     --Executed aftereach row change- :NEW, :OLD are available
     AFTER EACH ROW IS
     BEGIN
       NULL;
     END AFTER EACH ROW;
   
     --Executed after DML statement
     AFTER STATEMENT IS
     BEGIN
       NULL;
     END AFTER STATEMENT;

END compound_trigger_name;

Popularity 6/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: oracle sql

Link to this answer
Share Copy Link

Contributed on May 09 2022

Carlos Roberto Báez Leiva

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

compound trigger oracle

Contents

More Related Answers

compound trigger oracle

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.