Oracle Identity Column
Channel: Data Science Center
Date: 15/04/2021

Oracle Identity Column
Syntax:


GENERATED [ ALWAYS | BY DEFAULT [ ON NULL ] ]
AS IDENTITY [ ( identity_options ) ] 

  1  create table deptt
  2     (
  3      dept_id number Generated by default as identity start with 10 increment by 2,
  4      dept_name varchar2(30)
  5*     )
  6  /