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 vote265 views1 answer
Show table details postgresql
SQL
1 vote259 views1 answer
How to select rows with no matching entry in another table?
SQL
1 vote271 views1 answer
Mysql select all and rename one
SQL
13 votes236 views3 answers
Uninstall mysql centos 7
SQL
0 vote281 views2 answers
Add colum in sql
SQL
4 votes254 views1 answer
Id primary key auto generated
SQL
0 vote253 views1 answer
Sql beginning of previous month
SQL
2 votes271 views1 answer
Column names in oracle sql
SQL
0 vote241 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote279 views1 answer
Mysql trigger to delete old data
SQL