sql set new identity column code example

Example 1: insert into table with only identity column

INSERT INTO TABLE_NAME DEFAULT VALUES

Example 2: 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->