/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 vote238 views1 answer
Mssql last day of month
SQL
1 vote207 views1 answer
Alter add syntax
SQL
1 vote210 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote249 views1 answer
Mysql c commands
SQL
1 vote350 views1 answer
Sql check roles
SQL
1 vote194 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote214 views1 answer
Sql server concat null
SQL
0 vote221 views1 answer
Get schema of table sql
SQL
0 vote205 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
1 vote321 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL