/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 vote388 views1 answer
Remove mysql from centos 7
SQL
0 vote330 views1 answer
How to find username and password in oracle 18c
SQL
2 votes319 views1 answer
Apex date today add days
SQL
2 votes708 views1 answer
Oracle virtual column
SQL
0 vote331 views1 answer
Mysql root localhost run
SQL
0 vote331 views1 answer
Edit shchima table in sql
SQL
0 vote351 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
3 votes383 views5 answers
No module named 'MySQLdb'
SQL
0 vote346 views1 answer
Insert or update sql firebird
SQL
0 vote423 views1 answer
Sqlite display data in separated columns
SQL