/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 vote247 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote267 views1 answer
Selecting all columns from table sql database
SQL
0 vote271 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote260 views1 answer
Sql server concat null
SQL
0 vote267 views1 answer
Get who is hired in month in sql
SQL
15 votes262 views6 answers
Drop foreign key mysql
SQL
11 votes272 views5 answers
Laravel db facade
SQL
0 vote254 views1 answer
TSQL function split string
SQL
0 vote291 views1 answer
How to compile a function in oracle
SQL
2 votes246 views1 answer
Sql ignore accents
SQL