/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 vote314 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote313 views2 answers
Oracle chain rules
SQL
0 vote281 views1 answer
Plpgsql if statement
SQL
-2 votes314 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote310 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
9 votes282 views6 answers
Sql add column with default value
SQL
0 vote384 views1 answer
Oracle db timestamp auto add
SQL
2 votes306 views1 answer
Sql string_agg
SQL
0 vote288 views1 answer
How to connect pgadmin with excel
SQL
0 vote282 views1 answer
T-SQL - Where Used List (Table/View)
SQL