This article explains how to create an autonumber for an oracle table. Autonumbers use a before insert trigger to retrieve an sequence value and assign the value to a primary key field. Autonumbers insure the uniqueness of the primary key.
Directed to article by OraclePower.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help