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

0 vote251 views1 answer
Create table employees oracle
SQL
4 votes281 views4 answers
Oracle tablespace tables list
SQL
0 vote302 views1 answer
Dockerfile example for Django
SQL
0 vote309 views1 answer
Oracle chain step succeeded
SQL
1 vote275 views2 answers
Postgresql get difference in hours between two dates
SQL
0 vote281 views1 answer
Check connections to database postgres
SQL
0 vote312 views1 answer
C# sql transaction multiple connections
SQL
26 votes262 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote303 views1 answer
Mysql bash execute sql file
SQL
0 vote265 views1 answer
How to convert DateTime to VarChar SQL
SQL