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: Steve Dancisin <sdancisin_removethis_at_highmark.com>
Date: Mon, 26 Jul 1999 11:30:42 -0400
Message-ID: <7nhvdc$7e1@news1.highmark.com>


Plus a tigger on the table.

-sd

Kingsley Sawyers wrote in message <7nhu31$po3$1_at_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:30:42 CDT

Original text of this message

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