/SQL/Oracle create table auto generated primary key

Oracle create table auto generated primary key

-- For oracle 12c or later 
-- auto inc
create table t1 (
    c1 NUMBER GENERATED by default on null as IDENTITY,
    c2 VARCHAR2(10)
    );
-- More options for initial value and increment value
create table t1 (
    c1 NUMBER GENERATED ALWAYS as IDENTITY(START with 1 INCREMENT by 1),
    c2 VARCHAR2(10)
    );

Source: stackoverflow.com

Similar codes

1 vote226 views2 answers
Grab part of a string sql
SQL
0 vote214 views1 answer
How to query all tables mysql at the same time
SQL
0 vote228 views1 answer
Query by column for substring sql
SQL
2 votes226 views1 answer
Sql update from different table
SQL
0 vote212 views1 answer
Replace multiple string in query sql
SQL
0 vote231 views3 answers
Constraint sql
SQL
24 votes236 views5 answers
List mysql users
SQL
0 vote234 views1 answer
Add mysql database to power bi web
SQL
0 vote213 views1 answer
Sauvegarde complète my sql
SQL
3 votes215 views1 answer
Force using index oracle
SQL