Facebook
From Putrid Duck, 8 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 416
  1. CREATE OR REPLACE TRIGGER  "KLUBY_T2"
  2. BEFORE
  3. insert or update or delete on "KLUBY"
  4. for each row
  5. begin
  6.  if :NEW.ID_KLUBU is null then
  7.     :NEW.ID_KLUBU := KLUBY_SEQ.nextval;
  8.   end if;
  9. end;
  10.  
  11. /
  12. ALTER TRIGGER  "KLUBY_T2" ENABLE
  13. /
  14.