Sql sequence

CREATE SEQUENCE seq_tipo MINVALUE 1;
ALTER TABLE tipo 
ALTER codt SET DEFAULT nextval('seq_tipo');

/*insert into YOUR_COLUMN_NAME VALUES (nextval('seq_tipo'), 'value_2')*/

Sql sequence

CREATE SEQUENCE sequence-name
    START WITH initial-value
    INCREMENT BY increment-value
    MAXVALUE maximum-value
    CYCLE | NOCYCLE;

Source: studytonight.com

Similar codes

5 votes126 views1 answer
List foreign key oracle
SQL
0 vote153 views1 answer
How to get button for every record from mysql
SQL
2 votes207 views1 answer
Oracle list grants on package
SQL
1 vote146 views1 answer
Oracle stop
SQL
16 votes151 views6 answers
Python sqlite
SQL
0 vote209 views1 answer
Add user mysql wordpress
SQL
10 votes146 views1 answer
All_dependencies
SQL
0 vote131 views1 answer
Set default value now() date
SQL
1 vote193 views1 answer
Sql server delete top 1000
SQL
0 vote150 views2 answers
Php convert dbf to mysql
SQL