Re: Sequences at Oracle

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 25 Oct 2001 09:34:25 GMT
Message-ID: <9r8mb1$ftb$1@news.liv.ac.uk>

,Yaron Avior <yavior_at_mercury.co.il> wrote:
: Hi,
: In SQL-Server, when you enter a new record to a table with an
: identity, this column's value is inserted automaticly after the last
: value is incremented.
: is it the same at Oracle (if I have a sequence) or I need to increment
: the sequence myself?
: can someone bring an example???

: thanks.

Go to http://asktom.oracle.com and do a search on sequence trigger.

HTH Helen

/\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ ( oo ) ( oo ) ( oo ) ( oo ) ( oo ) ( ** ) ( oo ) ( oo ) ( oo ) ( oo ) ( oo ) =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= Received on Thu Oct 25 2001 - 04:34:25 CDT