⚙️ Triggers
Row-level triggers for auditing and validation.
| Snippet | |
|---|---|
| ☆BEFORE INSERT — Row trigger fired before each insert |
CREATE TRIGGER trg_bi BEFORE INSERT ON emp FOR EACH ROW BEGIN NULL; END;
|
| ☆AFTER DELETE — Row trigger fired after each delete |
CREATE TRIGGER trg_ad AFTER DELETE ON emp FOR EACH ROW BEGIN NULL; END;
|
| ☆SALARY CHECK — Validate new row values and reject bad data |
CREATE OR REPLACE TRIGGER trg_sal_check BEFORE INSERT ON emp FOR EACH ROW BEGIN IF :NEW.salary < 0 THEN RAISE_APPLICATION_ERROR(-20002, 'Negative Salary'); END IF; END;
|