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

0 vote410 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote366 views1 answer
Oracle list subpartitions
SQL
1 vote363 views1 answer
Select not matching data with join table
SQL
1 vote343 views1 answer
Import local sql into remote mysql
SQL
1 vote369 views1 answer
Oracle drop chain step
SQL
0 vote318 views1 answer
Mysql find foreign key references
SQL
0 vote373 views1 answer
Not equal to blank in mysql
SQL
0 vote449 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote397 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
1 vote347 views1 answer
Set mysql mode global query
SQL