Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Compilation errors in TRIGGER
Sunil Natraj wrote:
> In the Trigger use this statement
>
> select seq1.nextval into :new.id from dual;
>
> It should work.
>
Thanks to all. It works now :o)
OOI, could someone tell me what ':new.id' means? And 'from dual'?
Thanks,
![]() |
![]() |