Creating a Table on Oracle Database with an Identity Column
UPDATE: I was informed by an Oracle Database expert that starting with Oracle 12c, you can indeed have an identity column, and no trigger or sequence is required. The below post still applies to Oracle 11g and older. If most of your database experience is with SQL Server (as mine is), you’re probably used to … Read more