Autonumber facility? Beginner question...

From: Robert Blomstrand <rbl_at_qmedia.co.za>
Date: Wed, 2 Feb 2000 16:57:20 +0200
Message-ID: <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_at_qmedia.co.za as well as the newsgroup.

Many thanks. Received on Wed Feb 02 2000 - 08:57:20 CST