/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 votes218 views1 answer
Set auto increment from 1
SQL
2 votes208 views1 answer
Mysql select default if null
SQL
17 votes228 views4 answers
Show tables sql server
SQL
18 votes202 views6 answers
Drop table if exists
SQL
0 vote191 views1 answer
Declaring variables in pl sql
SQL
4 votes215 views1 answer
Search column by name mysql
SQL
0 vote207 views1 answer
To change the database owner in SQL server
SQL
0 vote204 views1 answer
Reona
SQL
0 vote236 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
4 votes208 views1 answer
Describe table mysql
SQL