Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Autonumber facility? Beginner question...
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_at_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_at_qmedia.co.za as well as the newsgroup.
>
>Many thanks.
>
>
>
Received on Wed Feb 02 2000 - 09:57:14 CST