/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 vote192 views1 answer
Select all columns except one sql
SQL
6 votes195 views1 answer
Oracle pl sql source
SQL
0 vote187 views1 answer
Sql remove last 2 digit
SQL
0 vote178 views1 answer
Oracle array
SQL
0 vote213 views1 answer
Doctors appointment
SQL
0 vote150 views1 answer
Big query add table rows to another table
SQL
0 vote163 views1 answer
How to to get current date and time in sql
SQL
0 vote176 views1 answer
Oracle table free space
SQL
12 votes179 views1 answer
Docker mysql random root password
SQL
0 vote177 views1 answer
Run mssql server terminal
SQL