Create sequence sequence_name increment by 1 start with 1;


Pat

  _____  

From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: May 19, 2004 16:15
To: CF-Talk
Subject: Re: oracle unique id or identity

Daniel Kessler wrote:
> I'm trying to make an auto-incrementing ID field in ORACLE.  In sql,
> I believe that I make it have an attribute of IDENTITY.

Use a sequence in Oracle.

Jochem
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to