Oracle auto_increment

-- Use a sequence:
CREATE SEQUENCE id_seq START WITH 1;
INSERT INTO my_table (ID, VALUE) VALUES (id_seq.NEXTVAL, 'My value');

Oracle auto increment primary key

CREATE TABLE auto_increment_column_table (
 auto_increment_column_id NUMBER GENERATED ALWAYS AS IDENTITY,
 auto_increment_column_description VARCHAR2(50)
);

Source: arungudelli.com

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

1 vote113 views1 answer
Postgresql can you have null foreign key
SQL
0 vote110 views3 answers
Find below average salary in sql
SQL
4 votes150 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
2 votes96 views1 answer
Sql to char function with date
SQL
0 vote122 views1 answer
Replace string in whole database mysql stackoverflow
SQL
7 votes124 views2 answers
Create mysql user
SQL
0 vote115 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote112 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote110 views1 answer
Mysql add to number
SQL
5 votes179 views1 answer
Oracle asynchronous procedure
SQL