Pl sql auto increment

CREATE OR REPLACE TRIGGER dept_bir 
BEFORE INSERT ON departments 
FOR EACH ROW

BEGIN
  SELECT dept_seq.NEXTVAL
  INTO   :new.id
  FROM   dual;
END;
/

Source: stackoverflow.com

Pl sql auto increment

CREATE TABLE departments (
  ID           NUMBER(10)    NOT NULL,
  DESCRIPTION  VARCHAR2(50)  NOT NULL);

ALTER TABLE departments ADD (
  CONSTRAINT dept_pk PRIMARY KEY (ID));

CREATE SEQUENCE dept_seq START WITH 1;

Source: stackoverflow.com

Similar codes

1 vote125 views1 answer
How to delete data from sql database in android
SQL
1 vote134 views3 answers
Get all tables postgres
SQL
-1 vote149 views2 answers
Import data from excel to sql server automatically
SQL
0 vote140 views1 answer
Utiliser sql ligne de commande
SQL
0 vote136 views1 answer
Sql count * vs count 1
SQL
2 votes139 views1 answer
Express api ith mysql data
SQL
2 votes189 views1 answer
Oracle block
SQL
7 votes143 views1 answer
Connect mysql docker
SQL
3 votes147 views1 answer
Oracle get trigger ddl
SQL
1 vote160 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL