Oracle SQL & PL/SQL: IDENTITY

IDENTITY (Property) SQL IDENTITY (Property) creates an identity column in a table. Syntax: IDENTITY [ ( seed , increment ) ] Example 1 of IDENTITY (Property) CREATE TABLE EMP (id_number int IDENTITY(1,1), nick_name varchar (20)) INSERT EMP VALUES ...

sql-plsql.blogspot.com