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

0 vote189 views1 answer
Get cpu details sql
SQL
1 vote172 views1 answer
How to test for sql injection
SQL
1 vote184 views1 answer
Mysql how to reset primary key
SQL
-1 vote191 views1 answer
How to reset autoincrement in sqlite java
SQL
0 vote170 views1 answer
Oracle tablespace autoextend
SQL
1 vote177 views2 answers
Mysql current user
SQL
0 vote141 views1 answer
Mysql collation for all languages
SQL
1 vote171 views1 answer
Local sql server
SQL
7 votes162 views1 answer
Forge server hosting
SQL
0 vote208 views4 answers
Convert databse to achieve log mode oracle
SQL