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 vote183 views1 answer
Sql sum show 0 result
SQL
0 vote180 views1 answer
Mysql date time string format for marshmellow field schema
SQL
2 votes186 views1 answer
Mysql select default if null
SQL
0 vote169 views1 answer
We are intrested to work with your organization
SQL
0 vote302 views1 answer
Provera dupliranih konatakata
SQL
1 vote170 views1 answer
Mysql get domain from url
SQL
0 vote301 views2 answers
Mysql insert rows to another database
SQL
5 votes202 views5 answers
Find max number in sql
SQL
0 vote164 views1 answer
SQL Server format datetime
SQL
3 votes182 views1 answer
Increment integer in table sql
SQL