/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 vote343 views1 answer
Pl sql drop trigger
SQL
3 votes286 views1 answer
System.debug apex
SQL
0 vote301 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote293 views1 answer
How to get n result in sql
SQL
0 vote277 views0 answer
SQL
7 votes328 views4 answers
Lowest salary in sql
SQL
0 vote292 views1 answer
Dump only schema
SQL
0 vote346 views1 answer
Mysql dump with table query
SQL
1 vote291 views1 answer
Mysql find tables with column name
SQL
4 votes359 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL