Re: Autonumber in Oracle
From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Wed, 22 Sep 1999 09:09:13 +0100
Message-ID: <7sa2rb$56a$1_at_taliesin.netcom.net.uk>
Date: Wed, 22 Sep 1999 09:09:13 +0100
Message-ID: <7sa2rb$56a$1_at_taliesin.netcom.net.uk>
Mike Phillips <mlp_at_swsdot.com> wrote in message
news:%10G3.4066$OT2.136386_at_wbnws01.ne.mediaone.net...
> Question: Is there autonumber functinality in oracle like in access?
Also,
> is it still a good idea then,
> to create a separate artificial recordID (autonumber) column for each
table
> as the primary key. Or should we actually use real column values, for
eg.:
> the combination of 'PartNumber+VendorID' values as the primary key for
the
> tables, keeping in mind that in the end all records in a relational table
> must be unique. I personally liked the autonumber
> idea in MSAccess.
Check out sequences in the docs
Alex Received on Wed Sep 22 1999 - 10:09:13 CEST