Xref: alice comp.databases.oracle.misc:52354
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.wirehub.nl!xs4all!not-for-mail
From: "Fritz" <fritz_nospam@mail4u.nl>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Autonumber facility? Beginner question...
Date: Wed, 2 Feb 2000 16:57:14 +0100
Organization: XS4ALL Internet BV
Lines: 30
Message-ID: <879hs9$hof$1@news1.xs4all.nl>
References: <389847b6$0$35287@helios.is.co.za>
X-Trace: news1.xs4all.nl 949504713 18191 194.109.150.18 (2 Feb 2000 15:18:33 GMT)
X-Complaints-To: abuse@xs4all.nl
NNTP-Posting-Date: 2 Feb 2000 15:18:33 GMT
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

You can try to solve it using a sequence and a 'before-insert-row' trigger.

h.t.h.


Robert Blomstrand wrote in message <389847b6$0$35287@helios.is.co.za>...
>Please help someone with very little Oracle experience...
>
>I need to know if there is a facility similar to the Access "Autonumber"
>facility (please don't laugh at the reference to Access. I know you cannot
>compare it to Oracle).
>
>In Access you can allocate an Autonumber field in a table which will act as
>your primary key, and an incremented number will automatically be allocated
>to this field with each new row added to the table.
>
>If no such facility is available in Oracle, could someone please tell me
how
>to do this via a trigger.
>
>This greenhorn would appreciate any advice he can get  :^)
>
>Please copy any response to rbl@qmedia.co.za as well as the newsgroup.
>
>Many thanks.
>
>
>