Advertisement
Aguezz

SISI - QMO - Trigger

Aug 30th, 2022
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. CREATE OR REPLACE TRIGGER MSO.M_AREA_TRG BEFORE INSERT ON MSO.M_AREA REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW
  2. BEGIN
  3. <<COLUMN_SEQUENCES>>
  4. BEGIN
  5. IF INSERTING AND :NEW.ID_AREA IS NULL THEN
  6. SELECT M_AREA_SEQ.NEXTVAL INTO :NEW.ID_AREA FROM SYS.DUAL;
  7. END IF;
  8. END COLUMN_SEQUENCES;
  9. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement