Re: Sequence

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: 2000/01/31
Message-ID: <949327457.8136.0.pluto.d4ee154e@news.demon.nl>#1/1

Use
select sequencename.nextval
into :new.<primarykey column>
from dual;

Hth

--
Sybrand Bakker, Oracle DBA
Gary Knopp <gknopp_at_ascend.com> wrote in message
news:8743h2$se4_at_nntpa.cb.lucent.com...


>

> Is there away to assign a sequence number in a

> a before insert trigger event?  I can't seem to get

> this to work properly.

>

> Thanks

>

>

>

>

>

>

>

Received on Mon Jan 31 2000 - 00:00:00 CST