Check out example codes for "pl sql create table identity column". It will help you in understanding the concepts better.

Code Example 1

Copy
sql-> CREATE Table sg_atts (
id INTEGER GENERATED ALWAYS AS IDENTITY
(START WITH 2 
INCREMENT BY 2 
MAXVALUE 200 
NO CYCLE),
name STRING,
PRIMARY KEY (id));
Statement completed successfully
sql->

Learn ReactJs, React Native from akashmittal.com