Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. create or replace trigger pii_user_activation_trigger
  2. before insert on pii_user_activation
  3. for each row
  4. begin
  5. select seq_pii_user_activation.nextval
  6. into :new.id
  7. from dual;
  8. end;
  9.  
  10. create or replace trigger pii_user_activation_trigger
  11. before insert on pii_user_activation<
  12. for each row
  13. begin
  14. IF :new.id IS NULL THEN
  15. select seq_pii_user_activation.nextval
  16. into :new.id
  17. from dual;
  18. END IF;
  19. end;
  20.  
  21. create or replace trigger pii_user_activation_trigger
  22. before insert on pii_user_activation
  23. for each row
  24. begin
  25. IF( :new.id IS NULL )
  26. THEN
  27. select seq_pii_user_activation.nextval
  28. into :new.id
  29. from dual;
  30. END IF;
  31. end;
  32.  
  33. create or replace trigger pii_user_activation_trigger
  34. before insert on pii_user_activation
  35. for each row
  36. WHEN (NEW.id IS NULL)
  37. begin
  38. select seq_pii_user_activation.nextval
  39. into :new.id
  40. from dual;
  41. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement