Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER ContentMonitorChange
- AFTER INSERT OR UPDATE OR DELETE ON CCE_SUBSCRIBER
- BEGIN
- IF INSERTING
- THEN
- INSERT INTO CCE_STOREDCHANGECONTENT VALUES
- (strdSequence.NextValue,'INSERT','CCE_SUBSCRIBER');
- END IF;
- IF DELETING THEN
- INSERT INTO CCE_STOREDCHANGECONTENT VALUES
- (strdSequence.NextValue,'DELETE','CCE_SUBSCRIBER');
- END IF;
- IF UPDATING THEN
- INSERT INTO CCE_STOREDCHANGECONTENT VALUES
- ( strdSequence.NextValue, 'UPDATE','CCE_SUBSCRIBER');
- END IF;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement