Autonumber in Oracle
From: Mike Phillips <mlp_at_swsdot.com>
Date: Wed, 22 Sep 1999 04:16:28 -0400
Message-ID: <%10G3.4066$OT2.136386_at_wbnws01.ne.mediaone.net>
[Quoted] [Quoted] Question: Is there autonumber functinality in oracle like in access? Also, is it still a good idea then,
[Quoted] [Quoted] to create a separate artificial recordID (autonumber) column for each table [Quoted] as the primary key. Or should we actually use real column values, for eg.: [Quoted] the combination of 'PartNumber+VendorID' values as the primary key for the [Quoted] tables, keeping in mind that in the end all records in a relational table [Quoted] must be unique. I personally liked the autonumber idea in MSAccess.
Date: Wed, 22 Sep 1999 04:16:28 -0400
Message-ID: <%10G3.4066$OT2.136386_at_wbnws01.ne.mediaone.net>
[Quoted] [Quoted] Question: Is there autonumber functinality in oracle like in access? Also, is it still a good idea then,
[Quoted] [Quoted] to create a separate artificial recordID (autonumber) column for each table [Quoted] as the primary key. Or should we actually use real column values, for eg.: [Quoted] the combination of 'PartNumber+VendorID' values as the primary key for the [Quoted] tables, keeping in mind that in the end all records in a relational table [Quoted] must be unique. I personally liked the autonumber idea in MSAccess.
Mike Received on Wed Sep 22 1999 - 10:16:28 CEST