Re: Does Oracle has an automatic counter field data type?

Get into Oracle SQLPLUS and enter

help CREATE SEQUENCE

Sami Heikkinen (sheikkin_at_rieska.oulu.fi) wrote:
: Hi!
 

: Does Oracle has an automatic counter field data type for generating
: primary keys (incrementally) automatically. I need to implement this kind
: of surrogate key for tables. This kind of field type is used in MS Access
: and is type of counter field. It works like this: when a new record is
: added into table the primary key field is automatically generated by the
: DBMS without a need for user interference.

: --
: ================================================
: = Sami Heikkinen Department of Information =
: = Processing Science =
: = University of Oulu =
: = Finland =
: =----------------------------------------------=
: = MAIL: PHONES: =
: = Valkkyla 5 B 17 home: 08-3136530 =
: = 90100 OULU mobile 049-944251 =
: = job: 08-5652815 =
: = E-MAIL: =
: = sheikkin_at_rieska.oulu.fi =
: = Sami.P.Heikkinen_at_ntc.nokia.com =
: ================================================

--
While DSC may claim ownership of all my ideas (on or off the job),
DSC does not claim any responsibility for them. Warranty expired when you
opened this article and I will not be responsible for its contents or use.