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

2 votes315 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote269 views1 answer
Mysql find non alphanumeric characters
SQL
1 vote278 views1 answer
Display total number of tables in mysql
SQL
58 votes580 views6 answers
Create new user in postgres
SQL
0 vote271 views1 answer
Sql python hwo to pass a list in paramerter
SQL
19 votes294 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote316 views1 answer
Sql: extract day text from datetime value
SQL
4 votes280 views1 answer
Adding data to table in sql python
SQL
0 vote275 views1 answer
Get time component of datetime sql
SQL
0 vote284 views1 answer
C# check if mysql query modified rows
SQL