/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

2 votes275 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote274 views1 answer
Enable Rabbitmq management plugin
SQL
1 vote287 views1 answer
Sql not equal multiple columns
SQL
0 vote313 views1 answer
Combine 2 columns search query mysql
SQL
0 vote220 views1 answer
Sqlalchemy existing database
SQL
5 votes250 views2 answers
Create table
SQL
0 vote270 views4 answers
Mysql select bottom 10 rows
SQL
0 vote287 views1 answer
Sql check if column exists
SQL
0 vote297 views1 answer
SQL FROM-Klausel
SQL
0 vote316 views1 answer
Get last inserted primary key
SQL