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: Autonumbering

Re: Autonumbering

From: Kingsley Sawyers <no_at_way.im.telling>
Date: Mon, 26 Jul 1999 16:16:56 +0100
Message-ID: <7nhu31$po3$1@lure.pipex.net>


This is done by creating a Sequence object, which can de referred to in the insert query. Check out the 'CREATE SEQUENCE' command.

Kingsley

kev wrote in message <379C79EA.3CA8B12A_at_fast.no>...
>Hi,
>
>I'm designing a database and need the id fields of my tables
>Autonumbered (ie incremented with every 'insert into...'.
>This is automatic on, say, M$ Access, but how do I do it in Oracle?
>
>- Kev
>
Received on Mon Jul 26 1999 - 10:16:56 CDT

Original text of this message

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