Re: Oracle Sequence for generating IDs

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Fri, 15 Jan 1999 11:45:42 -0500
Message-ID: <369f70df.0@news.mountain.net>

if you have just selected the nextval from the sequence, you can use the mysequence.curval to find the value you just selected.

Kenny Gump
OCP 7.3 DBA

---

Paul wrote in message <369e7041.7901288_at_news.dial.pipex.com>...
>I am using sequences to generate primary keys for tables. If I use
>triggers to generate the next ID in the sequence automatically what is
>the best way to find out what ID was generated in Visual Basic. Any
>help is appreciated.
>
>Paul
Received on Fri Jan 15 1999 - 10:45:42 CST