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

3 votes185 views2 answers
Oracle for loop
SQL
0 vote220 views1 answer
Write a query to peint the pattern P(20)
SQL
2 votes190 views1 answer
Drop table if exists in postgres
SQL
0 vote211 views1 answer
Insert array into mysql column
SQL
1 vote201 views1 answer
Oracle rolling back transactions
SQL
0 vote202 views1 answer
Mysql table variables
SQL
0 vote202 views1 answer
Sqlite get date only
SQL
0 vote160 views1 answer
Sql server is not
SQL
0 vote191 views1 answer
Oracle job class
SQL
0 vote266 views1 answer
Oracle convert int to date
SQL