Answers for "how to create an identity column in oracle 12c"

SQL
-1

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->
Posted by: Guest on June-24-2020

Code answers related to "how to create an identity column in oracle 12c"

Code answers related to "SQL"

Browse Popular Code Answers by Language