Oracle auto increment primary key

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

Similar codes

0 vote169 views1 answer
Mysql dump for selected row
SQL
0 vote150 views1 answer
Psotgres multiple values
SQL
1 vote156 views1 answer
Sql server update column based on another table
SQL
1 vote137 views1 answer
Mysql count all table rows
SQL
0 vote194 views1 answer
Sql alter table add column if exists
SQL
2 votes176 views1 answer
Mariadb json select
SQL
1 vote162 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
10 votes196 views4 answers
Sql server pagination
SQL
0 vote196 views1 answer
Postgresql find biggest table
SQL
13 votes104 views2 answers
Oracle all source
SQL