Google News
logo
SQL - Interview Questions
What is Autoincrement?
In all databases generating primary key value automatically is called auto-increment concept. In Oracle, we are implementing the auto-increment concept by using row-level triggers, sequences. i.e here we creating sequence in SQL and use this sequence in PL/SQL row-level trigger.
SQL> create table test (sno number(10), primary key, name varchar2(10));
Advertisement