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 vote145 views1 answer
Less than and between in sql query
SQL
0 vote139 views1 answer
Postgres where
SQL
0 vote144 views1 answer
Join in update query in mysql
SQL
3 votes157 views1 answer
Oracle function return
SQL
0 vote130 views2 answers
Functions with parameters SQL
SQL
0 vote136 views1 answer
Sqlite select split string
SQL
17 votes140 views3 answers
Cast in sql server
SQL
0 vote205 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote175 views1 answer
Mysql relationships between tables
SQL
0 vote141 views1 answer
Search starting with mysql
SQL