Oracle Database 12c New Features Free Tutorials: Identity Column

In Oracle 11g and earlier releases, “identity” columns, or numeric primary keys such as, for example a transaction number , where often handled by creating NUMBER column, a sequence, and a trigger to populate the column with unique, sequential numbers. Net: Work for the DBA or Developer. Clumsy: doing programmatically what the RDBMS should do by itself

Oracle 12c eliminates the need for sequences and triggers with the “identity column” feature, manifested in the new clause “generated as identity”.

In this tutorial, Oracle Certified Master John Watson will demonstrate the old and the new technique and, as he often does, reverse engineers the feature to show how Oracle actually implements it. Just for good measure John adds a few other useful insights.

Date: Feb 14, 2013

Need to Learn 12c New Features?   Class Starts November 17, with Oracle Master John Watson

NOTE: Some corporate firewalls will not allow videos hosted by YouTube.

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

 

×
Podcast
×