Re: Compilation errors in TRIGGER

You wrote ":new.id" in your original post and you're asking what it means? Lookup ":new" and ":old" and you'll see that this syntax can be used in triggers to refer to new and old column values in triggers. "dual" is a weird Oracle pseudo-table that you can select system variable values from, like SYSDATE, sequence .NEXTVAL and .CURRVAL, etc. If you want to get really confused DESCRIBE dual...

kev wrote:

> 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,
>
> - Kev
Received on Thu Jul 29 1999 - 09:34:51 CDT