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 vote391 views1 answer
Show tables in cassandra cql
SQL
0 vote398 views1 answer
Order child below the parent in mysqli
SQL
1 vote357 views2 answers
How to search date in sql query
SQL
0 vote313 views1 answer
Testing sql queries
SQL
4 votes367 views4 answers
Pl sql output
SQL
0 vote365 views1 answer
Formatting code with SQL Developer
SQL
0 vote368 views1 answer
Oracle sql log to console
SQL
0 vote379 views1 answer
Postgres list all stored procedures query
SQL
2 votes352 views1 answer
Brew start postgres manual
SQL
0 vote344 views1 answer
Sql orcale i forgot what my name & password was
SQL