/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

0 vote360 views1 answer
Postgres populate table from another table
SQL
0 vote381 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote373 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote352 views1 answer
Sql get month from date
SQL
0 vote379 views1 answer
ORA-13717
SQL
0 vote355 views1 answer
Python mysql query to dataframe
SQL
18 votes341 views3 answers
Mysql number format
SQL
0 vote384 views1 answer
Mysql query with sql to get the next row
SQL
5 votes376 views6 answers
In operator sql
SQL
0 vote351 views1 answer
Sql datediff month
SQL