Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Compilation errors in TRIGGER

Re: Compilation errors in TRIGGER

From: kev <kevin.porter_at_fast.no>
Date: Thu, 29 Jul 1999 15:06:16 +0100
Message-ID: <37A05FD8.B2858897@fast.no>


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,

Received on Thu Jul 29 1999 - 09:06:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US