Re: Autonumbering

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