/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

4 votes126 views4 answers
Oracle tablespace tables list
SQL
0 vote128 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote115 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
4 votes121 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote158 views1 answer
Generate sql from specific migration ef core
SQL
2 votes115 views2 answers
Join update query in sql
SQL
0 vote136 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote131 views1 answer
Delete a record from a table sqlite3
SQL
0 vote128 views2 answers
Sql query in dax power bi
SQL
0 vote127 views1 answer
Limit and offset in stored procedure mssql
SQL