/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 vote158 views1 answer
Enable sql server full text indexing
SQL
0 vote106 views2 answers
Postgresql could not start server mac
SQL
2 votes104 views1 answer
Sql group by different columns
SQL
1 vote145 views1 answer
Postgres first_value in gropby
SQL
0 vote169 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote150 views3 answers
How to increase size of column in sql
SQL
0 vote234 views1 answer
Python mysql check if database exists
SQL
0 vote148 views2 answers
Database owner can't create new tables postgres
SQL
0 vote144 views1 answer
Postgresql interview questions
SQL
3 votes270 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL