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: Problems with SEQUENCES!

Re: Problems with SEQUENCES!

From: R Fray <russ_at_u-net.net>
Date: Mon, 05 Oct 1998 16:38:46 GMT
Message-ID: <3618f5f0.355044341@news.u-net.com>

>I have a problem with SEQUENCES in databases. Although i think they are
>very usefull i don't know anything about their usage.
>How can i insert values into a table and use the defined sequence to
>generate a unique key value. Defining the sequence is no problem.
>I'm working with WinNT 4.0 and Oracle 7.3.3 on an UNIX workstation.
>For conversation i use ODBC driver Ora ... v2.5

Hi,

Do you mean you want to create a trigger which auto-increments a field using a sequence? If so, I can post an example. If not, could you re-phrase the question?

Russ.

--

Russell Fray
U-NET Ltd. Received on Mon Oct 05 1998 - 11:38:46 CDT

Original text of this message

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