0

I want to create Oracle trigger in Toad Modeler 5.3. This is the table:

enter image description here

In my case I need to add userID using trigger.

I'm stuck here:

enter image description here

enter image description here

Can you help me what should be the trigger body?

EDIT: Something like this?

create sequence t1_seq start with 1 increment by 1 nomaxvalue; 

BEGIN
    select t1_seq.nextval into :new.id_increment from dual;
END
Peter Penzov
  • 1,126
  • 134
  • 430
  • 808
  • 1
    You'd need to create a sequence (a separate object). The trigger would then use the sequence. An example of that is in the duplicate question. – Justin Cave May 15 '15 at 08:12
  • @JustinCave Post updated. By the way where I have to specify which column is updated? Sorry but I don't have experience with SQL. – Peter Penzov May 15 '15 at 08:20

0 Answers0