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

7 votes198 views2 answers
Where keyword sql
SQL
3 votes159 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
1 vote170 views1 answer
Oracle sql create or replace view
SQL
1 vote180 views1 answer
Oracle apex run 404
SQL
0 vote221 views1 answer
Sqlite display headers on columns
SQL
2 votes187 views4 answers
Mysql get all tables row count
SQL
1 vote177 views1 answer
Oracle lock user
SQL
3 votes259 views1 answer
Oracle cannot access v$session
SQL
5 votes192 views1 answer
How to get all dates in a month in oracle
SQL
1 vote138 views1 answer
Postgres kill pid
SQL