Answers for "sql set new identity column"

pl sql create table identity column

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->

insert into table with only identity column

INSERT INTO TABLE_NAME DEFAULT VALUES