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 programatically 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, SkillBuilders’ Oracle 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. Visit www.SkillBuilders.com/Oracle-Tutorials for more free Oracle Database tutorials.
Course Features
- Lecture 1
- Quiz 0
- Duration 8 minutes
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
