Oracle Identity Column
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 /