Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.51 KB | None | 0 0
  1. CREATE TRIGGER ContentMonitorChange
  2.  AFTER INSERT OR UPDATE OR DELETE ON CCE_SUBSCRIBER
  3.  
  4.  BEGIN
  5.      IF INSERTING
  6.      THEN
  7.         INSERT INTO CCE_STOREDCHANGECONTENT  VALUES
  8.         (strdSequence.NextValue,'INSERT','CCE_SUBSCRIBER');
  9.      END IF;
  10.      IF DELETING THEN
  11.         INSERT INTO CCE_STOREDCHANGECONTENT  VALUES
  12.         (strdSequence.NextValue,'DELETE','CCE_SUBSCRIBER');
  13.      END IF;   
  14.      IF UPDATING THEN
  15.         INSERT INTO CCE_STOREDCHANGECONTENT  VALUES
  16.         ( strdSequence.NextValue, 'UPDATE','CCE_SUBSCRIBER');  
  17.      END IF;
  18.  END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement