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

9 votes163 views6 answers
Oracle substring
SQL
0 vote140 views1 answer
Dataframe lambda elif
SQL
1 vote133 views4 answers
Psql check tables command
SQL
5 votes143 views3 answers
Oracle list columns in schema
SQL
1 vote146 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote128 views1 answer
Declare date variable sql
SQL
1 vote133 views1 answer
How to test for sql injection
SQL
0 vote180 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
1 vote158 views1 answer
Oracle plan hash value
SQL
-1 vote129 views1 answer
Round up and down sql
SQL