Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create or replace trigger pii_user_activation_trigger
- before insert on pii_user_activation
- for each row
- begin
- select seq_pii_user_activation.nextval
- into :new.id
- from dual;
- end;
- create or replace trigger pii_user_activation_trigger
- before insert on pii_user_activation<
- for each row
- begin
- IF :new.id IS NULL THEN
- select seq_pii_user_activation.nextval
- into :new.id
- from dual;
- END IF;
- end;
- create or replace trigger pii_user_activation_trigger
- before insert on pii_user_activation
- for each row
- begin
- IF( :new.id IS NULL )
- THEN
- select seq_pii_user_activation.nextval
- into :new.id
- from dual;
- END IF;
- end;
- create or replace trigger pii_user_activation_trigger
- before insert on pii_user_activation
- for each row
- WHEN (NEW.id IS NULL)
- begin
- select seq_pii_user_activation.nextval
- into :new.id
- from dual;
- end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement