Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Need to create a AUTO INCREMENT field...

Re: Need to create a AUTO INCREMENT field...

From: Maarten Scharroo <Maarten.Scharroo_at_wkap.nl>
Date: 2000/08/10
Message-ID: <39925051.40BF57B5@wkap.nl>#1/1 






Hi,



Use a sequence to fetch a unique id. Use a BEFORE INSERT TRIGGER to
populate the field.



Maarten



CS Raghavendra Prasad wrote:



> Hello all.,

>     I want to create a table with one of the fields which auto

> increments

>     itself as records are added.

>     How can I do this...

>

> Regards

> Raghu

Received on Thu Aug 10 2000 - 00:00:00 CDT












Original text of this message













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