Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Autonumbering
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
![]() |
![]() |