/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 vote355 views1 answer
Leftjoin in sql
SQL
28 votes312 views6 answers
Distinct sql
SQL
0 vote354 views2 answers
Postgres show current role
SQL
0 vote371 views1 answer
Top 3 salary in sql
SQL
0 vote347 views1 answer
Mysql disable query caching
SQL
5 votes341 views1 answer
Mysql get last day of month
SQL
0 vote328 views1 answer
AddEntityFrameworkSqlite
SQL
1 vote351 views1 answer
Moodle query item quiz
SQL
0 vote326 views1 answer
Alter precision
SQL
0 vote354 views1 answer
Mysql shell ERROR: Not connected.
SQL